Sorting with ORDER BY

Sorting the result

The rows come back in no particular order. Add ORDER BY to sort them by a column:

SELECT name, score FROM student ORDER BY score DESC;

ASC sorts ascending (smallest first) — this is the default.
DESC sorts descending (largest first).

Sorting by more than one column

Sort text columns alphabetically:

SELECT name FROM student ORDER BY name;

You can sort by several columns: ORDER BY form ASC, score DESC sorts by form first, then by score within each form. ORDER BY always comes last in the query.

Show every student's name and score, highest score first.

SELECT name, score FROM student ORDER BY score ...;

Click Run to see the output here.

Show every student's name, sorted alphabetically (A to Z).

SELECT name FROM student ORDER BY ...;

Click Run to see the output here.

Next lesson →

Sorting with ORDER BY

Sorting the result

Sorting by more than one column

Handout

Sign in

Log in or create account