1.

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» B. “the ranking function “row_number” must have an over by clause.”


Discussion

No Comment Found