Cursusinhoud
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:
sql
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 start coding
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.
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je 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:
sql
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 start coding
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.
Oplossing
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande optiesBedankt voor je feedback!
Schakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande opties