where not

[CoolB]

SELECT * FROM Customers
WHERE NOT Country='Germany' AND NOT Country='USA'and not country="Mexico";

 

I am new to SQL and learning "where not" syntax. Wonder how can I make the above string shorter? or any other way this can be written? how do I use <> here?

[justsomeguy]

Use the not equal operator in place of the equal operator.

[Morshed Chittagong]

On 8/27/2019 at 6:51 AM, CoolB said:

SELECT * FROM Customers
WHERE NOT Country='Germany' AND NOT Country='USA'and not country="Mexico";

 

I am new to SQL and learning "where not" syntax. Wonder how can I make the above string shorter? or any other way this can be written? how do I use <> here?

SELECT * FROM Customers
WHERE  Country NOT IN ( 'Germany','USA','Mexico');

u can use NOT IN( ) operator.

[Sherin]

You have declare where with  not operator it is using where clause after you have column_name declare and after not operator

select * from Customers

Where Country Not In ('Germany','USA','Mexico')

 

Edited February 5, 2020 by Sherin