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.
2.7k
0
Do you find this helpful?
26

Discussion

No comments yet