Apprendre 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;

Tâche

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.

Solution

Tout était clair ?

Merci pour vos commentaires !

Section 1. Chapitre 3

single

Demandez à l'IA

Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion

Suggested prompts:

Résumer ce chapitre

Expliquer le code dans file

Expliquer pourquoi file ne résout pas la tâche

Awesome!

Completion rate improved to 16.67

Glissez pour afficher le menu


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