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:

Taak

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.

Oplossing

Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande opties

Was alles duidelijk?

Bedankt voor je feedback!

Sectie 2. Hoofdstuk 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:

Taak

Swipe to start coding

Oplossing

Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande opties

Was alles duidelijk?

Bedankt voor je feedback!

Sectie 2. Hoofdstuk 3

Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande opties