SQL INTERSECT

Write SQL to INTERSECTof two or more statements.

The SQL INTERSECT operator is used to combine two SELECT statements but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement

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

Oracle

SELECT * FROM EMPLOYEE WHERE ID IN(1,2)
INTERSECT 
SELECT * FROM EMPLOYEE WHERE ID IN (1)

Result

Table: Employee                            
+----+-------+--------+--------------+     
| Id | Name  | Salary | DepartmentId |     
+----+-------+--------+--------------+     
| 1  | Ram   | 85000  | 1            |     
+----+-------+--------+--------------+