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:

Compito

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.

Soluzione

Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguenti

Tutto è chiaro?

Grazie per i tuoi commenti!

Sezione 2. Capitolo 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:

Compito

Swipe to start coding

Soluzione

Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguenti

Tutto è chiaro?

Grazie per i tuoi commenti!

Sezione 2. Capitolo 3

Cambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguenti