Course Content
Introduction to SQL
Introduction to SQL
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:
SELECT DISTINCT region FROM country;
Here's a short example of the country
table:
Swipe to show code editor
You have to retrieve distinct (unique) continent
values.
Thanks for your feedback!
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:
SELECT DISTINCT region FROM country;
Here's a short example of the country
table:
Swipe to show code editor
You have to retrieve distinct (unique) continent
values.
Thanks for your feedback!
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:
SELECT DISTINCT region FROM country;
Here's a short example of the country
table:
Swipe to show code editor
You have to retrieve distinct (unique) continent
values.
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:
SELECT DISTINCT region FROM country;
Here's a short example of the country
table:
Swipe to show code editor
You have to retrieve distinct (unique) continent
values.