Not equal to query for SQL server

Question

I tried to execute a query that gets all the information from the Merchant table, where PackageID is not 21 or 22 or 23 ..

Select * from Merchant where PackageID NOT '22' Union Select * from Merchant where PackageID Not '21'

Thanks!!

Answer 1

use PackageID NOT IN (21, 22, 23 ..)

Select * from Merchant where PackageID NOT IN (21, 22, 23) 

Answer 2

 SELECT * FROM Merchant WHERE Packageid NOT IN ('21', '22', '23') 

Answer 3

SELECT * From seller WHERE PackageID NOT IN ('21', '22', '23')

Answer 4

 Select * from Merchant where PackageID NOT IN ('21', '22', '23') 

Answer 5

You can use NOT IN to do this:

 select * from Merchant where PackageID not in ('21','22')