Exam4Training

The OVER clause makes this what type of function?

Consider this SQL statement:

SELECT product, prod_cost, avg(prod_cost) OVER (PARTITION BY product)

FROM product_detail

The OVER clause makes this what type of function?
A . Window function
B . Aggregate function
C . System function
D . User-defined function

Answer: A

Exit mobile version