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

No comments: