Order By Limit

Order Amount Descending

ORDER BY amount DESC presents higher numeric values before lower values.

highlighted = computed this step

Input table

Use the same order rows so the descending order can be compared directly.

Orders\text{Orders}
Ordersorder_idcategoryamounto1book30o2pen12o3book12o4paper45o5pen30

Order query

Sort rows by amount from high to low.

ORDER BY amount DESC\text{ORDER BY amount DESC}
ORDER BY amount descendingorder by amount descarity 3 rows 5Ordersarity 3 rows 5

Ordered output

Duplicate amount rows stay separate because ORDER BY does not dedupe.

amount descending\text{amount descending}
Ordered outputorder_idcategoryamounto4paper45o1book30o5pen30o2pen12o3book12