The Project | About Us | Contribute | Donations | License

HOME

In this section, we will learn how to sort data in SQL using the ORDER BY clause. Sorting data is a fundamental operation that allows you to organize query results in a specific order, making it easier to analyze and understand the data.

Key Concepts

ORDER BY Clause: Used to sort the result set of a query by one or more columns.
Ascending Order (ASC): Default sorting order, which arranges data from the lowest to the highest value.
Descending Order (DESC): Arranges data from the highest to the lowest value.
Multiple Columns: You can sort by multiple columns, specifying the order for each.

Basic Syntax

The basic syntax for the ORDER BY clause is as follows:

SELECT column1, column2, ...
FROM table_name
ORDER BY column1 [ASC|DESC], column2 [ASC|DESC], ...;

column1, column2, ...: The columns by which you want to sort the data.
ASC: Sorts the data in ascending order (default).
DESC: Sorts the data in descending order.

Practical Examples

Example 1: Sorting by a Single Column

Let's consider a table named employees with the following data:

employee_id	first_name	last_name	salary
1	John	Doe	50000
2	Jane	Smith	60000
3	Alice	Johnson	55000
4	Bob	Brown	45000

To sort the employees by their salary in ascending order:

SELECT employee_id, first_name, last_name, salary
FROM employees
ORDER BY salary ASC;

Result:

employee_id	first_name	last_name	salary
4	Bob	Brown	45000
1	John	Doe	50000
3	Alice	Johnson	55000
2	Jane	Smith	60000

Example 2: Sorting by a Single Column in Descending Order

To sort the employees by their salary in descending order:

SELECT employee_id, first_name, last_name, salary
FROM employees
ORDER BY salary DESC;

Result:

employee_id	first_name	last_name	salary
2	Jane	Smith	60000
3	Alice	Johnson	55000
1	John	Doe	50000
4	Bob	Brown	45000

Example 3: Sorting by Multiple Columns

To sort the employees first by last_name in ascending order and then by first_name in ascending order:

SELECT employee_id, first_name, last_name, salary
FROM employees
ORDER BY last_name ASC, first_name ASC;

Result:

employee_id	first_name	last_name	salary
4	Bob	Brown	45000
1	John	Doe	50000
3	Alice	Johnson	55000
2	Jane	Smith	60000

Practical Exercises

Exercise 1: Sorting by a Single Column

Given the following products table:

product_id	product_name	price
1	Laptop	1000
2	Smartphone	800
3	Tablet	600
4	Monitor	300

Write a query to sort the products by price in ascending order.

Solution:

SELECT product_id, product_name, price
FROM products
ORDER BY price ASC;

Exercise 2: Sorting by Multiple Columns

Given the same products table, write a query to sort the products first by price in descending order and then by product_name in ascending order.

Solution:

SELECT product_id, product_name, price
FROM products
ORDER BY price DESC, product_name ASC;

Common Mistakes and Tips

Omitting the ORDER BY clause: If you don't specify ORDER BY, the result set will not be sorted in any particular order.
Incorrect column names: Ensure that the column names specified in the ORDER BY clause exist in the table.
Mixing ASC and DESC: You can mix ASC and DESC in a single ORDER BY clause, but be clear about which columns should be sorted in which order.

Conclusion

In this section, we learned how to use the ORDER BY clause to sort data in SQL. We covered the basic syntax, practical examples, and exercises to reinforce the concepts. Sorting data is a crucial skill for organizing and analyzing query results effectively. In the next section, we will learn how to limit the number of results returned by a query using the LIMIT clause.

Sorting Data with ORDER BY

Key Concepts

Basic Syntax

Practical Examples

Example 1: Sorting by a Single Column

Example 2: Sorting by a Single Column in Descending Order

Example 3: Sorting by Multiple Columns

Practical Exercises

Exercise 1: Sorting by a Single Column

Exercise 2: Sorting by Multiple Columns

Common Mistakes and Tips

Conclusion

SQL Course

Module 1: Introduction to SQL

Module 2: Basic SQL Queries

Module 3: Working with Multiple Tables

Module 4: Advanced Data Filtering

Module 5: Data Manipulation

Module 6: Advanced SQL Functions

Module 7: Subqueries and Nested Queries

Module 8: Indexes and Performance Optimization

Module 9: Transactions and Concurrency

Module 10: Advanced Topics

Module 11: SQL in Practice

Module 12: Final Project