What is the appropriate sequence for the elements in a SQL query clause that displays the rows returned in a particular order?
A) command, operator (if any), major sort key, minor sort key
B) primary sort key followed by operator (if any), secondary sort key followed by operator (if any), command
C) command, major sort key followed by operator (if any), minor sort key followed by operator (if any)
D) command, secondary sort key followed by operator (if any), primary sort key followed by operator (if any)

Question

Quizplus · Accepted Answer

The correct sequence for elements in a SQL query clause that orders the rows returned is to first specify the command (e.g., SELECT), followed by the major (primary) sort key with an optional sorting operator (ASC for ascending or DESC for descending), and then the minor (secondary) sort key with an optional sorting operator. This sequence ensures that the data is sorted primarily by the major sort key and then within those sorted groups by the minor sort key.

What Is the Appropriate Sequence for the Elements in a SQL