McqMate
| Q. |
Point out the wrong statement. |
| A. | the row_number function simply assigns sequential numbering to the records of a result-set or to the records within groups of a result-set |
| B. | over clause is not required in all the ranking functions |
| C. | sql server introduced four different ranking functions |
| D. | all of the mentioned |
| Answer» B. over clause is not required in all the ranking functions | |
| Explanation: over clause is required in all the ranking functions and with that you specify the partitioning and ordering of records before the ranking functions are evaluated. | |
View all MCQs in
Information Retrival TechniquesNo comments yet