SQL SELECT DISTINCT Statement

In a table, some of the columns may contain duplicate values. This is not a problem, however, sometimes you will want to list only the different (distinct) values in a table.
The DISTINCT keyword can be used to return only distinct (different) values.

SQL SELECT DISTINCT Syntax

 

SELECT DISTINCT column_name(s)  FROM table_name

SELECT DISTINCT Example

“Persons” TABLE:

P_Id	LastName	FirstName	Address	City
1	Suhail	Osmani	Maharaj Nagar	Sitapur
2	Maxwel	Tom	Biswan	Sitapur
3	Rahi	Ayon	Okhla	Delhi

Now we want to select only the distinct values from the column named "City" from the table above.
We use the following SELECT statement:

SELECT DISTINCT City FROM Persons     or   SELECT City FROM Persons

Output:
 

City

Sitapur

Delhi