Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lära Sorting Data | Sorting Retrieved Data
Introduction to SQL
course content

Kursinnehåll

Introduction to SQL

Introduction to SQL

1. Retrieving Data
Retrieving Individual ColumnsRetrieving Multiple Columns Retrieving All ColumnsRetrieving Distinct RowsLimiting ResultsChallenge: Find the Population of the CountriesChallenge: Find All CountriesChallenge: Find All Countries With Their IDsChallenge: Find Country CapitalsChallenge: Find the Regions in Which All Countries Are Located
2. Sorting Retrieved Data
Sorting DataChallenge: Population SortSorting by Multiple ColumnsChallenge: Dual-Sort QuerySpecifying Sort DirectionChallenge: Sort the Countries by Region and CapitalChallenge: Sort Capitals in Descending OrderChallenge: Sort Countries in Ascending OrderChallenge: Find Countries, Their IDs, and Their PopulationsChallenge: Find Countries, IDs, Populations, Regions, and Sort ThemChallenge: Find All Continents and Sort Them in Ascending Order
3. Filtering Data
Using the WHERE ClauseChallenge: North America Population SortThe WHERE Clause Operators Challenge: Population Threshold QueryChecking for a Range of ValuesChecking for NO Value
4. Advanced Data Filtering
Using the AND OperatorChallenge: Europe Region SortUsing the OR operatorChallenge: America Regions FilterUsing the NOT OperatorChallenge: Non-Europe Capitals Sort
5. Aggregate Functions
The AVG() FunctionChallenge: Surface Area SelectionThe COUNT() FunctionChallenge: Continental CountThe MAX() FunctionThe MIN() FunctionChallenge: Large Surface Area AverageThe SUM() Function

book
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:


              
123

            
SELECT continent 
FROM country 
ORDER BY continent;
copy

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:

Uppgift

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.

Lösning

Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 2. Kapitel 1
toggle bottom row

book
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:


              
123

            
SELECT continent 
FROM country 
ORDER BY continent;
copy

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:

Uppgift

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.

Lösning

Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 2. Kapitel 1
Switch to desktopByt till skrivbordet för praktisk övningFortsätt där du är med ett av alternativen nedan
Vi beklagar att något gick fel. Vad hände?
some-alt