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
Latest D-DS-FN-23 Dumps Valid Version with 300 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments