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;

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 3

single

Swipe to show menu

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

single

Ask AI

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