SELECT DISTINCT

Published Jun 4, 2021Updated Sep 3, 2021

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;

to clipboardCopy to clipboard

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;

to clipboardCopy to clipboard

The given query would return: