Order By Limit

Order Amount Ascending

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

highlighted = computed this step

Input table

Start with five order rows and repeated amount values.

Orders\text{Orders}
Ordersorder_idcategoryamounto1book30o2pen12o3book12o4paper45o5pen30

Order query

Sort rows by amount from low to high.

ORDER BY amount ASC\text{ORDER BY amount ASC}
ORDER BY amount ascendingorder by amount ascarity 3 rows 5Ordersarity 3 rows 5

Ordered output

The same five rows remain, now presented in ascending amount order.

amount ascending\text{amount ascending}
Ordered outputorder_idcategoryamounto2pen12o3book12o1book30o5pen30o4paper45