M

Mr. Dubey • 52.30K Points
Coach

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
Correct : Option (C)

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.

Share

Discusssion

Login to discuss.

Be the first to start discuss.