AND

The WHERE condition clause allows us to define a condition and filter the data.

If there are more conditions, we can use the logical operator AND, which expresses „and at the same time“. This means that the query returns those records that meet all the conditions.

Structure:

SELECT column_name
FROM table_name
WHERE condition AND condition;

 

Example1:

We have a table Customer with this data:

 

SELECT name
FROM Customer
WHERE hair = 'blonde' AND salary>10;

Thor and Lucie meet these conditions. Both have blond hair and a salary of more than 10. Arnold has blond hair, but his salary is less than 10.