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;

Example

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:

city
Cleveland
Los Angeles
Golden State
Miami
Edit this page on GitHub

Contributors

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

Learn SQL on Codecademy