Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Retrieving Distinct Rows | Retrieving Data
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:

id name continent region surfacearea capital population
1 Japan Asia Eastern Asia 377829 Tokyo 126714000
2 Latvia Europe NULL 64589 Riga 2424200
3 Mexico North America Central America 1958201 Mexico City 98881000
4 Netherlands Europe Western Europe 41526 Amsterdam 15864000
... ... ... ... ... ... ...
15 Malta Europe Southern Europe 316 Valletta 380200

Task

You have to retrieve distinct (unique) continent values.

Everything was clear?

Section 1. Chapter 4
toggle bottom row
course content

Course Content

Introduction to SQL

Introduction to SQL

1. Retrieving Data

Retrieving Individual ColumnsRetrieving Multiple Columns Retrieving All ColumnsRetrieving Distinct RowsLimiting ResultsChallenge: Find the Population of the CountriesChallenge: Find All CountriesChallenge: Find All Countries With Their IDsChallenge: Find Country CapitalsChallenge: Find the Regions in Which All Countries Are Located

2. Sorting Retrieved Data

Sorting DataChallenge: Population SortSorting by Multiple ColumnsChallenge: Dual-Sort QuerySpecifying Sort DirectionChallenge: Sort the Countries by Region and CapitalChallenge: Sort Capitals in Descending OrderChallenge: Sort Countries in Ascending OrderChallenge: Find Countries, Their IDs, and Their PopulationsChallenge: Find Countries, IDs, Populations, Regions, and Sort ThemChallenge: Find All Continents and Sort Them in Ascending Order

3. Filtering Data

Using the WHERE ClauseChallenge: North America Population SortThe WHERE Clause Operators Challenge: Population Threshold QueryChecking for a Range of ValuesChecking for NO Value

4. Advanced Data Filtering

Using the AND OperatorChallenge: Europe Region SortUsing the OR operatorChallenge: America Regions FilterUsing the NOT OperatorChallenge: Non-Europe Capitals Sort

5. Aggregate Functions

The AVG() FunctionChallenge: Large Surface Area AverageThe COUNT() FunctionChallenge: Continental CountThe MAX() FunctionThe MIN() FunctionChallenge: Surface Area SelectionThe SUM() Function

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:

id name continent region surfacearea capital population
1 Japan Asia Eastern Asia 377829 Tokyo 126714000
2 Latvia Europe NULL 64589 Riga 2424200
3 Mexico North America Central America 1958201 Mexico City 98881000
4 Netherlands Europe Western Europe 41526 Amsterdam 15864000
... ... ... ... ... ... ...
15 Malta Europe Southern Europe 316 Valletta 380200

Task

You have to retrieve distinct (unique) continent values.

Everything was clear?

Section 1. Chapter 4
toggle bottom row
some-alt