Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator?

C2090-619 0 Comments

Which one keyword in this query makes the AVG an OLAP window expression instead of the regular aggregate operator?

SELECT AVG (SUM (dollars)) OVER () FROM sales;
A . SUM
B . OVER
C . FROM
D . AVG(SUM(dollars))

Answer: B

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments