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
Answer:A
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
Explanation:ORDER BY CLAUSE is not optional clause in ROW NUMBER function.