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":
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":
If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com
If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com