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';
Try it Yourself »

Copyright 1999-2023 by Refsnes Data. All Rights Reserved.