Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Aprenda Sorting by Multiple Columns | Sorting Retrieved Data
TEST SQL COURSE E2E

bookSorting 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.

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

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.

Solução

Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 1. Capítulo 3
single

single

Pergunte à IA

expand

Pergunte à IA

ChatGPT

Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo

close

Awesome!

Completion rate improved to 16.67

bookSorting by Multiple Columns

Deslize para mostrar o menu

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;
copy
Tarefa

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.

Solução

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

close

Awesome!

Completion rate improved to 16.67
Seção 1. Capítulo 3
single

single

some-alt