SQL AND Keyword
AND
The AND
command is used with WHERE to only include rows where both conditions is true.
The following SQL statement selects all fields from "Customers" where country is "Germany" AND city is "Berlin":
ExampleGet your own SQL Server
SELECT * FROM Customers
WHERE Country='Germany'
AND City='Berlin';
Try it Yourself »