MCQOPTIONS
Saved Bookmarks
| 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.†| |