Search⌘ K
AI Features
Home
Courses
Learn SQL from Scratch

Sorting Data

Explore how to effectively sort data in SQL queries using the ORDER BY clause with ASC or DESC options. Learn to retrieve limited records with the LIMIT keyword to generate refined reports, such as the top N sales transactions.

We'll cover the following...

Revisiting Task 1

Let’s revisit task 1, where we created a report listing salespersons. Here is what we did:

MySQL
SELECT DISTINCT SalesPerson
FROM SalesData

We had successfully generated the report. Nevertheless, we overlooked the requirement that the names of the salespersons in the sample report should be sorted in ascending order. 

Report 1: List of salespersons
Report 1: List of salespersons

To accomplish this, it is necessary to organize the results in ascending order. SQL provides a mechanism to streamline this process. By instructing SQL to arrange the outcomes in either ascending or descending order, the system effortlessly executes ...