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