6

CHAPTER 6

ORDER, BY

Controlling the sequence of your results.

Learning Blocks

Interactive Queries

Concepts you'll master

Ascending (ASC) and descending (DESC) sort

Sorting by multiple columns — primary and secondary sort

Sorting by expressions and aliases

SQL QUERY

SELECT name, salary 
FROM employees
ORDER BY salary ASC;

SQL QUERY

SELECT name, department, salary
FROM employees
ORDER BY department ASC, salary DESC;

🌟 Note: SQL reads ORDER BY columns left to right: first sort by department (A→Z), then within each department sort by salary (high→low).

Practice your SQL skills

SQL EDITOR

Interactive Query Environment

Press semicolon (;) to auto-run query

Complete all SQL challenges

Sort employees by salary in ascending order.

Current Task

Sort employees by salary in descending order.

Sort employees by department in alphabetical order.

Sort employees by department (A-Z) and within each department by salary (highest first).

Need help solving this task?