Which clause displays results in ascending or descending order?
AORDER OFF
BORDER OVER
CORDER BY
DORDER OUT
Answer & Solution
Correct answer: C. ORDER BY
1. Query results come back unsorted unless asked otherwise.
2. One clause imposes a sort.
3. The ORDER BY clause displays the result in ascending or descending order.
4. So the answer is ORDER BY.
_Source: syllabus Computer Science, Ch 9 'Structured Query Language (SQL)'_
Keep practising Structured Query Language
Browse all Structured Query Language questions for IGNOU MCA, or explore more Computer Science topics.