SQL•SQL References

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":

Example

SELECT * FROM Customers

WHERE Country='Germany'
AND City='Berlin';

Loading lesson path

SQL•SQL References

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":

Example

SELECT * FROM Customers

WHERE Country='Germany'
AND City='Berlin';