SQL Where 명령어

WHERE 조건식

-- 1, 2, 3, 4번 동일
-- 1) ANY : 어떤것이든, 아무거나
SELECT employee_id, SALARY
FROM EMPLOYEES
WHERE SALARY = ANY(2000, 3000, 4000)
ORDER BY employee_id;

-- 2)
SELECT employee_id, SALARY
FROM EMPLOYEES
WHERE SALARY IN (2000, 3000, 4000)
ORDER BY employee_id;

-- 3)
SELECT employee_id, SALARY
FROM EMPLOYEES
WHERE SALARY = 2000 OR SALARY = 3000 OR SALARY = 4000
ORDER BY employee_id;
-- 4)
SELECT employee_id, SALARY
FROM EMPLOYEES
WHERE SALARY = SOME(2000, 3000, 4000)
ORDER BY employee_id;

-- ALL은 AND 조건으로 변환 할수가 있다
-- ALL은 모든 조건을 동시에 만족해야 한다
SELECT employee_id, SALARY
FROM EMPLOYEES
WHERE SALARY = ALL(2000, 3000, 4000)
ORDER BY employee_id;

-- 1, 2번 동일한 결과
-- 1) BETWEEN A AND B (조건식)
-- 2000~4000 사이
SELECT employee_id, SALARY
FROM EMPLOYEES
WHERE SALARY BETWEEN 2000 AND 4000
ORDER BY employee_id;
-- 2)
SELECT employee_id, SALARY
FROM EMPLOYEES
WHERE SALARY >= 2000 AND SALARY <= 4000
ORDER BY employee_id;

-- NOT 조건식
SELECT employee_id, SALARY
FROM EMPLOYEES
WHERE NOT (SALARY >= 2500)
ORDER BY employee_id;

SELECT employee_id, SALARY
FROM EMPLOYEES
WHERE NOT (SALARY < 2500)
ORDER BY employee_id;