DESC

noun

say it: “DEE-ESS-SEE” /ˌdiː ɛs ˈsiː/ or “DESK” /dɛsk/

The word in ORDER BY that sorts from highest to lowest, Z to A.

What does DESC do in a relational database?

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

SELECT order_id, ordered_on
FROM purchase_order
ORDER BY ordered_on DESC;

In a sentence

  • “ORDER BY OrderDate DESC shows the newest orders first.”

Level: Novice · More SQL terms at this level

Updated