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

Course Content

Introduction to SQL

Introduction to SQL

1. Retrieving Data
2. Sorting Retrieved Data
3. Filtering Data
4. Advanced Data Filtering
5. Aggregate Functions

bookRetrieving 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:

1
SELECT DISTINCT region FROM country;
copy

Here's a short example of the country table:

Task
test

Swipe to show code editor

You have to retrieve distinct (unique) continent values.

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
toggle bottom row

bookRetrieving 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:

1
SELECT DISTINCT region FROM country;
copy

Here's a short example of the country table:

Task
test

Swipe to show code editor

You have to retrieve distinct (unique) continent values.

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
toggle bottom row

bookRetrieving 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:

1
SELECT DISTINCT region FROM country;
copy

Here's a short example of the country table:

Task
test

Swipe to show code editor

You have to retrieve distinct (unique) continent values.

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!

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:

1
SELECT DISTINCT region FROM country;
copy

Here's a short example of the country table:

Task
test

Swipe to show code editor

You have to retrieve distinct (unique) continent values.

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
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