[ Programing ]/Database
[SQL] NOT 연산자
Mister_Q
2011. 8. 1. 21:15
- 포함하지 않거나, 제외된 조건으로 검색할 때 사용한다.
SELECT last_name, job_id
FROM employees
WHERE job_id
NOT IN ( 'IT_PROG', 'ST_CLERK', 'SA_REP' ); 그외 사용 하고 있는 NOT 연산자. ... WHERE job_id NOT IN ( 'AC_ACCOUNT', 'AD_VP' ) ... WHERE salary NOT BETWEEN 10000 AND 15000 ... WHERE last_name NOT LIKE '%A%' ... WHERE commission_pct IS NOT NULL
SELECT last_name, job_id
FROM employees
WHERE job_id
NOT IN ( 'IT_PROG', 'ST_CLERK', 'SA_REP' ); 그외 사용 하고 있는 NOT 연산자. ... WHERE job_id NOT IN ( 'AC_ACCOUNT', 'AD_VP' ) ... WHERE salary NOT BETWEEN 10000 AND 15000 ... WHERE last_name NOT LIKE '%A%' ... WHERE commission_pct IS NOT NULL