Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Sorting Data | Sorting Retrieved Data
course content

Course Content

Introduction to SQL

Sorting DataSorting Data

Furthermore, we have the ability to sort the data we receive in a specific order. To achieve this, we first retrieve the data using the SELECT operator and subsequently apply the ORDER BY clause. This clause accepts the names of columns based on which the output will be sorted. Let's explore an example to enhance our comprehension:

Note

It is essential that the ORDER BY clause comes last in the SELECT statement.

Explanation: In the example, you can observe that the ORDER BY clause sorts the data based on the continent column.

Task

First, select the capital column from the country table. Then, sort the data from the capital column, retrieved using the SELECT statement.

Here's a short example of the country table:

idnamecontinentregionsurfaceareacapitalpopulation
1JapanAsiaEastern Asia377829Tokyo126714000
2LatviaEuropeNULL64589Riga2424200
3MexicoNorth AmericaCentral America1958201Mexico City98881000
.....................
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 2. Chapter 1
toggle bottom row
course content

Course Content

Introduction to SQL

Sorting DataSorting Data

Furthermore, we have the ability to sort the data we receive in a specific order. To achieve this, we first retrieve the data using the SELECT operator and subsequently apply the ORDER BY clause. This clause accepts the names of columns based on which the output will be sorted. Let's explore an example to enhance our comprehension:

Note

It is essential that the ORDER BY clause comes last in the SELECT statement.

Explanation: In the example, you can observe that the ORDER BY clause sorts the data based on the continent column.

Task

First, select the capital column from the country table. Then, sort the data from the capital column, retrieved using the SELECT statement.

Here's a short example of the country table:

idnamecontinentregionsurfaceareacapitalpopulation
1JapanAsiaEastern Asia377829Tokyo126714000
2LatviaEuropeNULL64589Riga2424200
3MexicoNorth AmericaCentral America1958201Mexico City98881000
.....................
15MaltaEuropeSouthern Europe316Valletta380200

Everything was clear?

Section 2. Chapter 1
toggle bottom row
some-alt