SELECT DISTINCT

christian.dinh2481 total contributions
Published Jun 4, 2021Updated Sep 3, 2021
Contribute to Docs
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 |
All contributors
- christian.dinh2481 total contributions
- Victoria-DR22 total contributions
- Anonymous contributorAnonymous contributor3077 total contributions
- christian.dinh
- Victoria-DR
- Anonymous contributor
Looking to contribute?
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.