Excel to SQL · Lesson 3 of 12

Sort with ORDER BY

In Excel, you'd reach for

fxData > Sort (A to Z, Z to A, custom sort with levels)

ORDER BY sorts the result. Add DESC for largest first (Z to A), or leave it off for smallest first (A to Z).

Excel's "Add Level" in the custom sort box is just a second column after a comma: sort by region, then by quantity within each region.

Try itEdit the query, then Run

Showing 10 of 20 rows. Press Run to see them all.

Unlike sorting a sheet, this never rearranges the stored data. Every query gets its own sorted copy, so you can't break anything.

Your turn

List the 5 most expensive products: name and unit_price, most expensive first.

The practice data (7 tables)