SQL AND Clause

The AND clause is also known as conjunctive operator and used to combine multiple conditions in SQL statement.

Syntax:

SELECT * FROM tableName WHERE [condition1] AND [condition2]…AND [conditionN];

In case of AND clause all conditions should be true.

Example:

SELECT * FROM EMPLOYEE WHERE SALARY > 40000 AND AGE < 29;

Output:

EMP_ID EMP_NAME AGE SALARY 5 Parmender 28 45000 3 Nidhi 28 48000 2 Parmender 28 45000