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