다중 값, 단일 값

[다중값]

 

IN

-> IN == OR 이고

-> NOT IN == AND 이다.

 

SELECT *

FROM EMPLOYEES

WHERE DEPARTMENT_ID IN (70, 90, 100);

 

향상

 

SELECT FIRST_NAME

FROM EMPLOYEES

WHERE SALARY IN (6000, 7000, 8000, 9000);

 

SELECT FIRST_NAME

FROM EMPLOYEES

WHERE SALARY BETWEEN 6000 AND 9000;

 

 

 

SELECT FIRST_NAME

FROM EMPLOYEES

WHERE SALARY IN (

SELECT SALARY

FROM EMPLOYEES

WHERE SALARY

BETWEEN 6000 AND 9000

);