SQL - IN

IN 연산자

• WHERE 절 안에 여러 값을 지정할 수 있다.

 

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);


-- SELECT 문 삽입 가능
SELECT column_name(s)
FROM table_name
WHERE column_name IN (SELECT STATEMENT); 

-- ex)
SELECT * FROM Customers
WHERE Country IN (SELECT Country FROM Suppliers);


SELECT * FROM Customers
WHERE Country NOT IN ('Germany', 'France', 'UK');