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:
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 |
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 |
Everything was clear?
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:
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 |
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 |
Everything was clear?
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:
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 |
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 |
Everything was clear?
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 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 |