TEST SQL COURSE E2E

TEST SQL COURSE E2E

0%

1. Sorting Retrieved Data

In this section, we will learn how to sort retrieved data using the ORDER BY clause. This clause, which must be the last in the SELECT statement, can be used to sort data on one or more columns as needed.\n

Sorting by Multiple Columns

2. Retrieving Data

In this section, we will learn how to use the SQL SELECT statement to get a single table column, multiple table columns, and all table columns. We will also find out how to return unique values.

Retrieving Individual Columns

Retrieving Multiple Columns

Retrieving Distinct Rows

3. Failing init script

This section has failing init script

4. Long execution init script

This section has long execution init script

Contenido del Curso

TEST SQL COURSE E2E

TEST SQL COURSE E2E

1. Sorting Retrieved Data

Sorting Data Challenge Sorting by Multiple Columns

2. Retrieving Data

Retrieving Individual Columns Retrieving Multiple Columns Retrieving Distinct Rows

3. Failing init script

4. Long execution init script

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.


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

Tarea

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.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

¡Gracias por tus comentarios!

Sección 1. Capítulo 3

toggle bottom row

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.


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

Tarea

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.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

¡Gracias por tus comentarios!

Sección 1. Capítulo 3

toggle bottom row

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.


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

Tarea

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.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

¡Gracias por tus comentarios!

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;

Tarea

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.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

Sección 1. Capítulo 3

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

some-alt