SQL AND Keyword

Concept visual

SQL AND Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

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';

SQL AND Keyword

Concept visual

SQL AND Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

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';

SQL AND Keyword

SQL AND Keyword

AND Keyword

Previous

Next

And

The AND

Example

Previous

Next

SQL AND Keyword

SQL AND Keyword

AND Keyword

Previous

Next

And

The AND

Example

Previous

Next