ASC and DESC
The sort directions in ORDER BY: ASC for smallest first, the default, and DESC for largest first.
In more detail
Each sort key has its own direction, so ORDER BY team ASC, salary DESC lists teams alphabetically with the best paid person first in each. If you give no direction, ASC is used.
Related terms
- ORDER BY — The clause that sorts a query's answer by one or more columns, each ascending or descending.
Taught in
- Thirty Eight Percent More: Billing Models And Tags — CompTIA Cloud+ (CV0-004) Exam Prep
- Ordering And Limiting Results — PostgreSQL, Indexing & Relational Data Modeling