SELECT empno , ename , job FROM emp ;
job
SELECT job FROM emp ;
BETWEEN … AND sal>=1500 AND sal<=3000
1981
198111 ~ 19811231
'
SELECT * FROM emp WHERE hiredate BETWEEN '1-1 -81' AND '31-12-81' ;
BETWEEN … AND
smith
ename='smith'
SELECT * FROM emp WHERE ename='smith' ; smith
Oracle
SELECT * FROM emp WHERE ename='SMITH' ;
LIKE
SELECT * FROM emp
SELECT * FROM emp
>>==<<=
SQL<>!=
7369
<>
SELECT * FROM emp WHERE empno<>7369 ;
!=
SELECT * FROM emp WHERE empno!=7369 ;