Learn Sorting by Multiple Columns | Sorting Retrieved Data

We can also sort by several 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.


              1234
            
SELECT ID, population, capital 
FROM country 
ORDER BY population, capital;

Task

Swipe to start coding

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.

Solution

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 3

single

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Suggested prompts:

Summarize this chapter

Explain the code in file

Explain why file doesn't solve the task

Swipe to show menu


              1234
            
SELECT ID, population, capital 
FROM country 
ORDER BY population, capital;

Task

Swipe to start coding

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 3

single

Sorting by Multiple Columns

Solution

Awesome!

Sorting by Multiple Columns

Solution

Awesome!