SQL MINUS

Write SQL to MINUS of two or more statements.

The MINUS operator will retrieve all records from the first dataset and then remove from the results all records from the second dataset

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/ Oracle

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

Result

Table: Employee                            
+----+-------+--------+--------------+     
| Id | Name  | Salary | DepartmentId |     
+----+-------+--------+--------------+     
| 2  | Henry | 80000  | 2            |     
+----+-------+--------+--------------+