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:
12SELECT DISTINCT region FROM country;
Swipe to start coding
Write an SQL query to retrieve distinct (unique) continent
values from the country
table.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 2.44
Retrieving Distinct Rows
Swipe to show menu
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:
12SELECT DISTINCT region FROM country;
Swipe to start coding
Write an SQL query to retrieve distinct (unique) continent
values from the country
table.
Solution
Thanks for your feedback!
Awesome!
Completion rate improved to 2.44single