Swipe to show menu

Retrieving Distinct Rows

Note that the SELECT statement returns all rows in a given column. Nevertheless, what if we don't need all the values from a column (because they can be duplicated), and we only need unique values? For such cases, it is convenient to use the keyword DISTINCT. Moreover, this keyword is used immediately before the column names. Let's look at an example.


              1
            
SELECT DISTINCT region FROM country;

Task

Swipe to start coding

You have to retrieve distinct (unique) continent values.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 3

Ask AI

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

Retrieving Distinct Rows


              1
            
SELECT DISTINCT region FROM country;

Task

Swipe to start coding

You have to retrieve distinct (unique) continent values.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 3

Switch to desktop for real-world practiceContinue from where you are using one of the options below