How to select unique records from a table?

The DISTINCT statement is used to return only distinct (different) values.

Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values

Example:

Employee Table

emp_id emp_name salary dept_id manager_id
E1 Rahul 15000 D1 M1
E2 Manoj 15000 D1 M1
E3 James 55000 D2 M2
E4 Michael 25000 D2 M2
E5 Ali 20000 D10 M3
E6 Robin 35000 D10 M3
SELECT DISTINCT salary,dept_id FROM Employee;

Output

salary dept_id
15000 D1
55000 D2
25000 D2
20000 D10
35000 D10

Code Runner

Copy the below query in the code runner to see the result

SELECT DISTINCT salary,dept_id FROM Employee;