Which clause is used to sort query results by one or more columns?

Which clause is used to sort query results by one or more columns?

• A. WHERE
• B. ORDER BY
• C. LIMIT
• D. GROUP BY

Answer: (B)

Sorting query results is done with the ORDER BY clause. It arranges the rows by one or more columns, and you can specify the sort direction for each column, with ASC as the default and DESC to reverse it. When you list multiple columns, the first column is the primary sort key; ties are broken by the second column, and so on, providing a stable, meaningful order such as ordering by date and then by name within the same date. Other clauses serve different roles: WHERE filters which rows are included before any sorting, LIMIT restricts how many rows are returned after sorting, and GROUP BY collects rows into groups for aggregation rather than for ordering.

Sorting query results is done with the ORDER BY clause. It arranges the rows by one or more columns, and you can specify the sort direction for each column, with ASC as the default and DESC to reverse it. When you list multiple columns, the first column is the primary sort key; ties are broken by the second column, and so on, providing a stable, meaningful order such as ordering by date and then by name within the same date.

Other clauses serve different roles: WHERE filters which rows are included before any sorting, LIMIT restricts how many rows are returned after sorting, and GROUP BY collects rows into groups for aggregation rather than for ordering.