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?
where not
in SQL
Posted
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?