Q.

Which of the following will not raise error if not used?

A. over clause
B. order by clause
C. partition by clause
D. all of the mentioned
Answer» C. partition by clause
Explanation: partition by clause is not mandatory and when you specify a column/set of columns with partition by clause then it will divide the result-set into record groups/partitions.
628
0
Do you find this helpful?
8

Discussion

No comments yet