Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn Retrieving Distinct Rows | Retrieving Data
Introduction to SQL

Swipe to show menu

book
Retrieving Distinct Rows

Note that the SELECT statement returns all rows in a given column. However, what if we don't need all the values from a column, especially when they are duplicated, and we only need unique values?

For such cases, it is convenient to use the keyword DISTINCT, placed immediately before the column names. Let's take a look at an example:

12
SELECT DISTINCT region FROM country;
copy
Task

Swipe to start coding

Write an SQL query to retrieve distinct (unique) continent values from the country table.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 4

Ask AI

expand
ChatGPT

Ask anything or try one of the suggested questions to begin our chat

book
Retrieving Distinct Rows

Note that the SELECT statement returns all rows in a given column. However, what if we don't need all the values from a column, especially when they are duplicated, and we only need unique values?

For such cases, it is convenient to use the keyword DISTINCT, placed immediately before the column names. Let's take a look at an example:

12
SELECT DISTINCT region FROM country;
copy
Task

Swipe to start coding

Write an SQL query to retrieve distinct (unique) continent values from the country table.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 4
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt