Search⌘ K
AI Features
Home
Courses
Learn Intermediate SQL

Sorting Data

Explore how to sort SQL query results in ascending or descending order using the ORDER BY clause. Learn to retrieve specific numbers of records with LIMIT or TOP keywords, enabling you to create refined reports like top sales transactions. This lesson helps you manage and organize data output precisely.

We'll cover the following...

Revisiting report 1

Let’s revisit the part where we created a report listing salespersons. Here is what we did:

MySQL
SELECT DISTINCT SalesPerson
FROM SalesData;

Although we had successfully generated the report, 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 that end, SQL provides a mechanism to arrange the outcomes in either ascending or descending order.

Sorted in descending order
Sorted in descending order

The ...