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