Question

Ranking of queries is done by which of the following?

(a) Group by

(b) Order by

(c) Having

(d) Both Group by and Order by

I have been asked this question during an internship interview.

Query is from Recursive Queries and Aggregation Features topic in section SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Correct choice is (b) Order by

The best I can explain: Order by clause arranges the values in ascending or descending order where a default is ascending order.