100 Days of SQL


Day 53 – SQL AND Keyword

SQL AND keyword is a logical operator used to combine multiple conditions in a SQL statement. The AND operator requires that all conditions separated by it must be true for the overall condition to be true.

The syntax for using the AND operator in a SQL WHERE clause is as follows:

SELECT column1, column2, ...
FROM table_name
WHERE condition1 AND condition2 AND condition3 ...;

Here, condition1, condition2, condition3, etc. are the conditions to be evaluated, and the AND operator is used to combine them.

For example, the following SQL statement selects all records from the customers table where the country column is Germany and the city column is Berlin:

FROM customers
WHERE country = 'Germany' AND city = 'Berlin';

In this example, the two conditions separated by the AND operator must both be true for the overall condition to be true. Only records that meet both criteria will be returned by the SELECT statement.

Note that the AND operator can be used in conjunction with other logical operators, such as OR and NOT, to create more complex conditions in a SQL statement.