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:

Opgave

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.

Løsning

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder

Var alt klart?

Tak for dine kommentarer!

Sektion 2. Kapitel 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:

Opgave

Swipe to start coding

Løsning

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder

Var alt klart?

Tak for dine kommentarer!

Sektion 2. Kapitel 3

Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder