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_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

All contributors

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.

Learn SQL on Codecademy

Analyze Data with SQL

Learn to analyze data with SQL and prepare for technical interviews.

Includes 8 Courses

With Certificate

Beginner Friendly

Design Databases With PostgreSQL

Learn how to query SQL databases and design relational databases to efficiently store large quantities of data.

Includes 5 Courses

With Certificate

Beginner Friendly

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 Friendly