Which of the clause is not mandatory ?
A. OVER clause
B. ORDER BY clause
C. PARTITION BY clause
D. All of the mentioned
Answer:A
Which of the clause is not mandatory ?
A. OVER clause B. ORDER BY clause C. PARTITION BY clause D. All of the mentioned
Explanation:PARTITION BY clause is not mandatory and if you don’t specify it all the records of the result-set will be considered as a part of single record group.