criteria operators sql code example Example: where query in sql server SELECT * FROM Customers WHERE Country='Mexico';