7. 조건절 사용
select의 조건절
select 컬럼명 from 테이블명 where 조건절
< : 작은가
>
: 큰가
<= : 작거나 같은가
>=
: 크거나 같은가
= : 같은가
<>, !=, ^= : 다른가
select empno, ename, deptno
from emp
where deptno = 10;
select empno, ename, deptno
from emp
where deptno != 10;
select empno, ename, sal
from emp
where sal >= 1500;
select empno, ename, job, sal
from emp
where ename = 'FORD';
select empno, ename, job
from emp
where job = 'SALESMAN';
select empno, ename, job
from emp
where job <> 'CLERK';
select empno, ename, hiredate
from emp
where hiredate >= '1982/01/01';