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 |
Next Topic: SQL OR Clause with example. Previous Topic: SQL WHERE Clause with example.
