ASC

An ORDER BY direction that sorts from lower values to higher values.

What does ASC do in a relational database?

ASC — An ORDER BY direction that sorts from lower values to higher values.

SELECT order_id, ordered_on
FROM purchase_order
ORDER BY ordered_on ASC;

Level: Novice · More Database terms at this level

Updated September 27, 2026