Learn 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

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

Suggested prompts:

Summarize this chapter

Explain the code in file

Explain why file doesn't solve the task

Swipe to show menu


              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

Retrieving Distinct Rows

Solution

Awesome!

Retrieving Distinct Rows

Solution

Awesome!