What is the use of AND operator in SQL?

The AND operator allows the existence of multiple conditions in an SQL statement’s WHERE clause. Gives TRUE if all the conditions separated by AND is TRUE.

Syntax:

SELECT * FROM table_name WHERE condition1 AND condition2 and ...conditionN;

table_name: name of the table
condition1,2,..N : first condition, second condition and so on