SELECT DISTINCT

SELECT DISTINCT: It is used to select unique records from a table. Some tables may have duplicate values for a column. Distinct will eliminate these duplications.

Syntax:

SELECT DISTINCT column_name(s) FROM table_name

Example:

SELECT DISTINCT mobile_num FROM Employees