SELECT DISTINCT

Returns unique values in the specified column(s).

Syntax

The SELECT DISTINCT statement specifies that the statement is going to be a query that returns unique values in the specified column(s).

SELECT DISTINCT column_name
FROM table_name;

For a table teams having five rows:

city	name	wins	losses
Cleveland	Cavaliers	22	50
Los Angeles	Lakers	42	30
Los Angeles	Clippers	47	25
Golden State	Warriors	39	33
Miami	Heat	40	32

SELECT DISTINCT city
FROM teams;

The given query would return:

Interested in helping build Docs? Read the Contribution Guide or share your thoughts in this feedback form.