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_nameFROM 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 cityFROM teams;
The given query would return:
city |
---|
Cleveland |
Los Angeles |
Golden State |
Miami |