Oracle 2 AND, OR, NOT, BETWEEN, IN 조건> mgr이 7800이상이고 job이 MANAGER인 데이터추출 select * from emp where mgr>=7800 ans job='MANAGER' 조건> 부서가 10번 이거나 직급이 MANAGER인 자료를 추출 select * from emp where deptno=10 or job='MANAGER' select * from emp where not deptno=10 select * from emp where deptno10 select * from emp where comm is null; //null은 is로 뽑는다. select * from emp where comm is not null; select last_name, job_id, s.. 더보기 이전 1 ··· 44 45 46 47 48 49 50 ··· 151 다음