Course Content
Introduction to SQL
Introduction to SQL
Sorting Data
We can sort the data we receive in a specific order. To do this, we first retrieve the data using the SELECT operator and then apply the ORDER BY clause. This clause takes the names of columns based on which the output will be sorted.
Here's the syntax to help us understand:
Here is the example where we ordering the result by continent column:
SELECT continent FROM country ORDER BY continent;
It’s important to note that when you specify a column with integer values, the sorting will be done in ascending order. For string columns, the sorting will follow alphabetical order.
Also, the ORDER BY clause should be placed just before the LIMIT clause, if a LIMIT clause is included in the query.
Explanation: In the example, you can observe that the ORDER BY clause sorts the data based on the continent column.
Here is the country table we are working with:
Swipe to show code editor
Write an SQL query to retrieve the capital column from the country table. Then, 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
We can sort the data we receive in a specific order. To do this, we first retrieve the data using the SELECT operator and then apply the ORDER BY clause. This clause takes the names of columns based on which the output will be sorted.
Here's the syntax to help us understand:
Here is the example where we ordering the result by continent column:
SELECT continent FROM country ORDER BY continent;
It’s important to note that when you specify a column with integer values, the sorting will be done in ascending order. For string columns, the sorting will follow alphabetical order.
Also, the ORDER BY clause should be placed just before the LIMIT clause, if a LIMIT clause is included in the query.
Explanation: In the example, you can observe that the ORDER BY clause sorts the data based on the continent column.
Here is the country table we are working with:
Swipe to show code editor
Write an SQL query to retrieve the capital column from the country table. Then, 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