

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