CoolB Posted August 27, 2019 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?
justsomeguy Posted August 27, 2019 Posted August 27, 2019 Use the not equal operator in place of the equal operator.
Morshed Chittagong Posted September 24, 2019 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.
Sherin Posted February 5, 2020 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
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