Exam4Training

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

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

Exit mobile version