Sorting by Multiple Columns
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.
1234SELECT ID, population, capital FROM country ORDER BY population, capital;
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.
Ratkaisu
Kiitos palautteestasi!
single
Kysy tekoälyä
Kysy tekoälyä
Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme
Awesome!
Completion rate improved to 16.67Sorting by Multiple Columns
Pyyhkäise näyttääksesi valikon
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.
1234SELECT ID, population, capital FROM country ORDER BY population, capital;
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.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
Awesome!
Completion rate improved to 16.67single
