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

Course Content

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.

Task

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

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 1. Chapter 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.

Task

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

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 1. Chapter 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.

Task

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

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your 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.

Task

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

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Section 1. Chapter 1
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
some-alt