Sorting by Multiple Columns

We can also sort by multiple columns. We need to specify the column names separated by commas.

The first column specified in the sorting will have priority, and then the sorting will proceed according to the second column.

The syntax will look like this:

sql

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:


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

Here is the country table we are working with:

Task

Swipe to start coding

Write an SQL query to 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

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 2. Chapter 3

Sorting by Multiple Columns

We can also sort by multiple columns. We need to specify the column names separated by commas.

The first column specified in the sorting will have priority, and then the sorting will proceed according to the second column.

The syntax will look like this:

sql

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:


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

Here is the country table we are working with:

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 2. Chapter 3

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