Summary -

In this topic, we described about the Select Unique with detailed example.

SELECT UNIQUE used to retrieve distinct rows from existing table in database. By using SELECT UNIQUE statement, we can retrieve distinct rows from existing table. UNIQUE clause is used in old days. Now a days, DISTINCT clause is using as a replace for UNIQUE.

Syntax -

SELECT UNIQUE column_name 
 FROM table_name;
  • column_name – Represents the name of the column which is used to fetch identical values.
  • table_name - Represents the name of the table.

Examples

Let us consider below table(s) as an example table(s) to frame the SQL query for getting the desired results.

employee_details -

emp_id emp_name designation manager_id date_of_hire salary dept_id
001 Employee1 Director 2019-07-11 45000.00 1000
002 Employee2 Director 2019-07-11 40000.00 2000
003 Employee3 Manager Employee1 2019-07-11 27000.00 1000
004 Employee4 Manager Employee2 2019-10-08 25000.00 2000
005 Employee5 Analyst Employee3 2019-07-11 20000.00 1000
006 Employee6 Analyst Employee3 2019-10-08 18000.00 1000
007 Employee7 Clerk Employee3 2019-07-11 15000.00 1000
008 Employee8 Salesman Employee4 2019--09-09 14000.00 2000
009 Employee9 Salesman Employee4 2019-10-08 13000.00 2000

Scenario – Fetching distinct values from table.

Requirement – get unique designations from employee_details table. 

SELECT UNIQUE designation FROM employee_details;

By executing above query, we can fetch unique designationsw from employee_details table. The output was as follows –

designation
Analyst
Clerk
Director
Manager
Salesman