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:A
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
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.