select * from emp where deptno = 20;
select * from emp where hiredate >= '1982-01-01';
desc는 내림차순으로 정렬하는 것이다.
select * from emp where comm not in(300, 500, 1400);
select * from emp where comm in(300, 500, 1400);
select * from emp where sal not between 2000 and 3000;
select * from emp where sal between 2000 and 3000;