SQL AND Clause
The AND clause is also known as conjunctive operator and used to combine multiple conditions in SQL statement.
SELECT * FROM tableName WHERE [condition1] AND [condition2]…AND [conditionN];
In case of AND clause all conditions should be true.
SELECT * FROM EMPLOYEE WHERE SALARY > 40000 AND AGE < 29;
EMP_ID EMP_NAME AGE SALARY
5 Parmender 28 45000
3 Nidhi 28 48000
2 Parmender 28 45000
Next Topic: SQL OR Clause with example.
Previous Topic: SQL WHERE Clause with example.