SQL OR

Write SQL select query with OR conditions.

The OR operator displays a record if all the conditions separated by OR are TRUE

Example

Table: Employee                            
+----+-------+--------+--------------+     
| Id | Name  | Salary | DepartmentId |     
+----+-------+--------+--------------+     
| 1  | Ram   | 85000  | 1            |     
| 2  | Henry | 80000  | 2            |     
| 3  | Sam   | 60000  | 2            |     
| 4  | Shyam | 60000  | 1            |
| 5  | Geeta | 90000  | 1            |
| 6  | Sheet | 90000  | 1            |
| 7  | Leela | 80000  | 1            |
| 8  | Geeta | 70000  | 1            |
+----+-------+--------+--------------+

Approach:

Mysql

Query: Select employee who is earning more than or equal 85000 OR from department 1;

SELECT * FROM EMPLOYEE WHERE SALARY>=85000 OR DEPARTMENTID=1;

Oracle

Query: Select employee who is earning more than or equal 85000 OR from department 1;

SELECT * FROM EMPLOYEE WHERE SALARY>=85000 OR DEPARTMENTID=1;

Result: 

Table: Employee                            
+----+-------+--------+--------------+     
| Id | Name  | Salary | DepartmentId |     
+----+-------+--------+--------------+     
| 1  | Ram   | 85000  | 1            |     
| 4  | Shyam | 60000  | 1            |
| 5  | Geeta | 90000  | 1            |
| 6  | Sheet | 90000  | 1            |
| 7  | Leela | 80000  | 1            |
| 8  | Geeta | 70000  | 1            |
+----+-------+--------+--------------+