Question

Which of the following error message will be displayed if ORDER CLAUSE is not mentioned in ROW NUMBER function?

(a) “The ranking function “ROW_NUMBER” must have an ORDER BY clause.”

(b) “The ranking function “ROW_NUMBER” must have an OVER BY clause.”

(c) “The ranking function “ROW_NUMBER” must have an PARTITION BY clause.”

(d) All of the mentioned

This question was addressed to me during an interview.

My question is from Ranking in chapter Manipulating Data with Select of SQL Server

Answer 1

Correct answer is (a) “The ranking function “ROW_NUMBER” must have an ORDER BY clause.”

Explanation: ORDER BY CLAUSE is not optional clause in ROW NUMBER function.