SQL UNIQUE/ DISTINCT

Write SQL to fetch UNIQUE records.

The SELECT DISTINCT statement is used to return only DISTINCT / UNIQUE values

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: Select unique employee

Mysql: 

SELECT DISTINCT NAME FROM EMPLOYEE

Oracle: 

SELECT DISTINCT NAME FROM EMPLOYEE

Result: 

+--------+
| NAME   |
+--------+
| Ram    |
| Henry  |
| Sam    |
| Shyam  |
| Geeta  |
| Sheeta |
| Leela  |
+--------+