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
.
Solución
¡Gracias por tus comentarios!
single
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Resumir este capítulo
Explicar el código en file
Explicar por qué file no resuelve la tarea
Awesome!
Completion rate improved to 16.67
Sorting by Multiple Columns
Desliza para mostrar el menú
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
.
Solución
¡Gracias por tus comentarios!
Awesome!
Completion rate improved to 16.67single