Skip to content

Latest commit

 

History

History
5 lines (4 loc) · 331 Bytes

File metadata and controls

5 lines (4 loc) · 331 Bytes
SELECT name, city FROM customers WHERE city IN  ('San Diego', 'San Francisco', 'New York')

IN ➔ Instead of using a multitude of OR statements, we can use an IN statement.

SELECT name, city FROM customers WHERE city NOT IN  ('San Diego', 'San Francisco', 'New York')

NOT IN ➔ Works inversely to the IN statement.