use select statement in where clause sql code example

Example: where query in sql server

SELECT * FROM Customers
WHERE Country='Mexico';