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
Please follow and like us: