Not Equal to query for SQL server

Question

Hello,

I was trying to execute a query which gets me all the info from Merchant table where PackageID is not equal to 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

You can use the NOT IN clause for this:

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

Answer 4

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

Answer 5

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