Lære 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;

Opgave

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.

Løsning

Var alt klart?

Tak for dine kommentarer!

Sektion 1. Kapitel 3

single

Spørg AI

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Stryg for at vise menuen


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

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 1. Kapitel 3

single

Sorting by Multiple Columns

Løsning

Awesome!

Sorting by Multiple Columns

Løsning

Awesome!