Q.

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. “the ranking function “row_number” must have an order by clause.”
Explanation: order by clause is not optional clause in row number function.
730
0
Do you find this helpful?
1

View all MCQs in

Information Retrival Techniques

Discussion

No comments yet

Related MCQs