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.‚Äö√Ñ√∂‚àö√ë‚àöœÄ | |