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:
Here's a short example of the country
table:
Task
You have to retrieve distinct (unique) continent
values.
Task
You have to retrieve distinct (unique) continent
values.
Everything was clear?
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:
Here's a short example of the country
table:
Task
You have to retrieve distinct (unique) continent
values.
Task
You have to retrieve distinct (unique) continent
values.
Everything was clear?
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:
Here's a short example of the country
table:
Task
You have to retrieve distinct (unique) continent
values.
Task
You have to retrieve distinct (unique) continent
values.
Everything was clear?
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:
Here's a short example of the country
table:
Task
You have to retrieve distinct (unique) continent
values.