CoolB Posted August 27, 2019 Share Posted August 27, 2019 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 More sharing options...
justsomeguy Posted August 27, 2019 Share Posted August 27, 2019 Use the not equal operator in place of the equal operator. Link to comment Share on other sites More sharing options...
Morshed Chittagong Posted September 24, 2019 Share Posted September 24, 2019 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 More sharing options...
Sherin Posted February 5, 2020 Share Posted February 5, 2020 (edited) 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now