WHERE절 주요 연산자

-- and / or / LIKE

SELECT  dept_id, dept_name, location

FROM     DEPARTMENT

WHERE  location = '서울' or dept_name LIKE '영업%';

WHERE  location = '서울' and dept_name [NOT] LIKE '영업_';

-- in

SELECT  dept_id, dept_name, location

FROM     DEPARTMENT

WHERE  location [NOT] IN ('서울',부산');

-- between

SELECT  dept_id, dept_name, location

FROM     DEPARTMENT

WHERE dept_id >= 100 and dept_id <=300;

WHERE dept_id [NOT] BETWEEN 100 AND 300;

-- null

SELECT  dept_id, dept_name, location

FROM     DEPARTMENT

WHERE location IS NULL;

WHERE location IS NOT NULL;