Course Content
Introduction to SQL
Introduction to SQL
Sorting by Multiple Columns
We can also sort by multiple columns. We need to specify the column names separated by commas. Let’s look at the example that retrieves three columns and sorts the results by two of them: first by population
and then by capital
.
SELECT ID, population, capital FROM country ORDER BY population, capital;
Task
Retrieve four columns using the SELECT
statement, namely: continent
, region
, population
, and capital
(please retrieve these columns in this order). Then, sort the result by two of them: first by continent
, then by population
.
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 by Multiple Columns
We can also sort by multiple columns. We need to specify the column names separated by commas. Let’s look at the example that retrieves three columns and sorts the results by two of them: first by population
and then by capital
.
SELECT ID, population, capital FROM country ORDER BY population, capital;
Task
Retrieve four columns using the SELECT
statement, namely: continent
, region
, population
, and capital
(please retrieve these columns in this order). Then, sort the result by two of them: first by continent
, then by population
.
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 by Multiple Columns
We can also sort by multiple columns. We need to specify the column names separated by commas. Let’s look at the example that retrieves three columns and sorts the results by two of them: first by population
and then by capital
.
SELECT ID, population, capital FROM country ORDER BY population, capital;
Task
Retrieve four columns using the SELECT
statement, namely: continent
, region
, population
, and capital
(please retrieve these columns in this order). Then, sort the result by two of them: first by continent
, then by population
.
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!
We can also sort by multiple columns. We need to specify the column names separated by commas. Let’s look at the example that retrieves three columns and sorts the results by two of them: first by population
and then by capital
.
SELECT ID, population, capital FROM country ORDER BY population, capital;
Task
Retrieve four columns using the SELECT
statement, namely: continent
, region
, population
, and capital
(please retrieve these columns in this order). Then, sort the result by two of them: first by continent
, then by population
.
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 |