AND

The AND operator is employed with the WHERE clause to retrieve rows where both conditions are true. The provided SQL statement selects all fields from the “Customers” table where the country is “Germany” and the city is “Berlin”.

Example

SELECT * FROM Customers
WHERE Country=‘Germany’ AND City=‘Berlin’;