OR Clause

OR Clause in SQL

OR clause are use to combined two or more than two condition together, In this case you need at least one condition is true then return result.

Suppose you want to get those employee record who have more than 30000 salary or more than 5 year experience in that case you can combined these two condition by using OR clause.

SELECT columns  
FROM tables  
WHERE condition 1  
OR condition 2;  

Employee table

SELECT * from Employee
WHERE salary>30000 OR experience>5;

Result after using OR clause: Here return those employee records who have satisfy at least one conditon.