Jump to content

where not


CoolB

Recommended Posts

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?

Link to comment
Share on other sites

  • 4 weeks later...
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.

Link to comment
Share on other sites

  • 4 months later...

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 by Sherin
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...