SELECT DISTINCT
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 |
Contribute to Docs
- 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.
Learn SQL on Codecademy
- Skill path
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.Includes 9 CoursesWith CertificateBeginner Friendly17 hours - Skill path
Design Databases With PostgreSQL
Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.Includes 5 CoursesWith CertificateBeginner Friendly13 hours - Free course
Learn SQL
In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.Beginner Friendly5 hours