자격증/SQLD - 취득완료
다중 값, 단일 값
Ch's Lee
2025. 6. 17. 12:37
[다중값]
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
);