Why ordering matters in SQL

Introduction

Ordering data helps us see information in a clear and useful way. It makes it easier to find what we want quickly.

When you want to see a list of products sorted by price from cheapest to most expensive.

When you need to show students' scores from highest to lowest to find the top performers.

When you want to organize events by date so you can plan ahead.

When you want to display customer names in alphabetical order for easy lookup.

When you want to find the most recent orders by sorting by order date descending.

Syntax

SQL

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

ORDER BY sorts the results by one or more columns.

ASC means ascending order (smallest to largest). It is the default.

DESC means descending order (largest to smallest).

Examples

This lists products from cheapest to most expensive.

SQL

SELECT name, price
FROM products
ORDER BY price ASC;

This shows students with the highest scores first.

SQL

SELECT student_name, score
FROM exam_results
ORDER BY score DESC;

This orders events from earliest to latest date.

SQL

SELECT event_name, event_date
FROM events
ORDER BY event_date ASC;

This sorts customers alphabetically by last name, then by first name.

SQL

SELECT last_name, first_name
FROM customers
ORDER BY last_name ASC, first_name ASC;

Sample Program

This creates a table of employees, adds three employees, and then lists them ordered by salary from highest to lowest.

SQL

CREATE TABLE employees (
  id INT,
  name VARCHAR(50),
  salary INT
);

INSERT INTO employees (id, name, salary) VALUES
(1, 'Alice', 50000),
(2, 'Bob', 70000),
(3, 'Charlie', 60000);

SELECT name, salary
FROM employees
ORDER BY salary DESC;

Important Notes

Without ORDER BY, the database may return rows in any order, which can be confusing.

You can order by multiple columns to organize data more precisely.

Ordering large datasets can take more time, so use it when needed.

Summary

Ordering helps you see data in a meaningful sequence.

Use ORDER BY with ASC or DESC to control sorting direction.

Ordering makes it easier to find top, bottom, or specific data quickly.