ASC

noun

say it: “AY-ESS-SEE” /ˌeɪ ɛs ˈsiː/ or “ASK” /æsk/

The word in ORDER BY that sorts from lowest to highest, A to Z; it's the default.

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;

In a sentence

  • “ORDER BY ProductName ASC lists the products from A to Z.”

Level: Novice · More SQL terms at this level

Updated