Sorting direction keywords?
Interviewer Expectations for this Question
01
Core Competency
Assesses fundamental understanding of SQL & Databases conventions, runtime behavior, and memory/performance considerations.
02
Evaluation Criteria
Hiring managers look for precision, avoidance of ambiguous jargon, and ability to explain trade-offs under real production conditions.
Comprehensive Model Answer
Verified Solution
In the SQL ORDER BY clause, sorting direction is controlled by two keywords:
ASC(Ascending): Sorts from lowest to highest (1 to 9, A to Z, oldest date to newest). This is the default order if omitted.DESC(Descending): Sorts from highest to lowest (9 to 1, Z to A, newest date to oldest).
### Multi-Column Example:
SELECT product_name, category, price
FROM products
ORDER BY category ASC, price DESC;
This query sorts products alphabetically by category, and within each category sorts from most expensive to least expensive.
Candidate Response Strategy & Interview Tips
- Start with a concise one-sentence summary: Deliver a direct, confident answer first before expanding into nuances.
- Demonstrate real-world trade-offs: Discuss where this approach excels and when you would avoid it in production systems.
- Discuss complexity & edge cases: Proactively explain time/space complexity or boundary conditions (null values, scale limits).
- Prepare for interviewer follow-ups: Technical hiring panels frequently probe deeper into concurrency, backward compatibility, or alternative libraries.