Opposite the IN statement in SQL

Question

How can I do the opposite:

In other words, select all people whose last name is not Hansen or Pettersen.

Answer 1

WHERE lastname NOT IN ('Hansen', 'Pettersen') 

see the section "IN and NOT IN statements " in SQL as SQLite understands

Answer 2

 SELECT * FROM Persons WHERE LastName NOT IN ('Hansen','Pettersen') 

Answer 3

You can undo IN with NOT :

 SELECT * FROM Persons WHERE LastName NOT IN ('hansen', 'Pettersen') 

Answer 4

Just NOT IN :

 SELECT * FROM Persons Where LastName NOT IN (...) 

Answer 5

Cancel the condition with NOT.

 select * from persons where NOT (LastName IN ('Hansen','Pettersen'));