OR Clause


Prev Tutorial Next Tutorial

OR Clause

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.

Syntax

SELECT columns  
FROM tables  
WHERE condition 1  
OR condition 2;  

Employee table

emp_idnamesalaryexperience
101Amit240003
102Rahul3400010
103Sultan540002
104Gaurav460006
105Hitesh350004

Example

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.

emp_idnamesalaryexperience
102Rahul3400010
103Sultan540002
104Gaurav460006
105Hitesh350004

Prev Tutorial Next Tutorial

Advertisements




Facebook Likes

Advertisements