NOT IN operator

Question

NOT IN operator

Accepted Answer

NOT IN excludes rows whose column value appears in the list. Alice (Sales) and Carol (HR) are filtered out. Bob (Eng) is the only row that remains. NOT IN ('Sales', 'HR') is equivalent to dept != 'Sales' AND dept != 'HR'.