Course Content
TEST SQL COURSE E2E
TEST SQL COURSE E2E
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.
SELECT continent FROM country ORDER BY continent;
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.
Swipe to show code editor
Select the capital column from the country table. Next, sort the data from the capital column, retrieved using the SELECT statement.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
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.
SELECT continent FROM country ORDER BY continent;
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.
Swipe to show code editor
Select the capital column from the country table. Next, sort the data from the capital column, retrieved using the SELECT statement.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
Switch to desktop for real-world practiceContinue from where you are using one of the options below