Course Content
Introduction to SQL
Introduction to SQL
Sorting 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:
SELECT continent FROM country ORDER BY continent;
Note
It is essential that the
ORDER BY
clause comes last in theSELECT
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:
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 |
... | ... | ... | ... | ... | ... | ... |
15 | Malta | Europe | Southern Europe | 316 | Valletta | 380200 |
Thanks for your feedback!
Sorting 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:
SELECT continent FROM country ORDER BY continent;
Note
It is essential that the
ORDER BY
clause comes last in theSELECT
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:
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 |
... | ... | ... | ... | ... | ... | ... |
15 | Malta | Europe | Southern Europe | 316 | Valletta | 380200 |
Thanks for your feedback!
Sorting 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:
SELECT continent FROM country ORDER BY continent;
Note
It is essential that the
ORDER BY
clause comes last in theSELECT
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:
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 |
... | ... | ... | ... | ... | ... | ... |
15 | Malta | Europe | Southern Europe | 316 | Valletta | 380200 |
Thanks for your feedback!
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:
SELECT continent FROM country ORDER BY continent;
Note
It is essential that the
ORDER BY
clause comes last in theSELECT
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:
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 |
... | ... | ... | ... | ... | ... | ... |
15 | Malta | Europe | Southern Europe | 316 | Valletta | 380200 |