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

Conteúdo do Curso

TEST SQL COURSE E2E

TEST SQL COURSE E2E

1. Sorting Retrieved Data
Sorting DataChallengeSorting by Multiple Columns
2. Retrieving Data
Retrieving Individual ColumnsRetrieving Multiple Columns Retrieving Distinct Rows
3. Failing init script
4. Long execution init script

book Sorting Data

Moreover, we can sort the receiving data. To do this, we first need to get the data by using the SELECT operator, then the ORDER BY clause. The ORDER BY clause accepts column names by which the output will be sorted accordingly. Let's look at an example for better understanding.


              
1234

            
SELECT continent 
FROM country 
ORDER BY continent;
copy

It is essential that the ORDER BY clauses come last in the SELECT operator.

Explanation: In the example, we can see that the ORDER BY clause sorts the data by the continent column.

Tarefa

Select the capital column from the country table. Next, sort the data from the capital column, retrieved using the SELECT statement.

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!

Seção 1. Capítulo 1
toggle bottom row

book Sorting Data

Moreover, we can sort the receiving data. To do this, we first need to get the data by using the SELECT operator, then the ORDER BY clause. The ORDER BY clause accepts column names by which the output will be sorted accordingly. Let's look at an example for better understanding.


              
1234

            
SELECT continent 
FROM country 
ORDER BY continent;
copy

It is essential that the ORDER BY clauses come last in the SELECT operator.

Explanation: In the example, we can see that the ORDER BY clause sorts the data by the continent column.

Tarefa

Select the capital column from the country table. Next, sort the data from the capital column, retrieved using the SELECT statement.

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!

Seção 1. Capítulo 1
toggle bottom row

book Sorting Data

Moreover, we can sort the receiving data. To do this, we first need to get the data by using the SELECT operator, then the ORDER BY clause. The ORDER BY clause accepts column names by which the output will be sorted accordingly. Let's look at an example for better understanding.


              
1234

            
SELECT continent 
FROM country 
ORDER BY continent;
copy

It is essential that the ORDER BY clauses come last in the SELECT operator.

Explanation: In the example, we can see that the ORDER BY clause sorts the data by the continent column.

Tarefa

Select the capital column from the country table. Next, sort the data from the capital column, retrieved using the SELECT statement.

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!

Moreover, we can sort the receiving data. To do this, we first need to get the data by using the SELECT operator, then the ORDER BY clause. The ORDER BY clause accepts column names by which the output will be sorted accordingly. Let's look at an example for better understanding.


              
1234

            
SELECT continent 
FROM country 
ORDER BY continent;
copy

It is essential that the ORDER BY clauses come last in the SELECT operator.

Explanation: In the example, we can see that the ORDER BY clause sorts the data by the continent column.

Tarefa

Select the capital column from the country table. Next, sort the data from the capital column, retrieved using the SELECT statement.

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Seção 1. Capítulo 1
Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
some-alt