What is the mandatory Clause that must be included when using Window functions?
A.
OVER
B.
RANK
C.
PARTITION BY
D.
RANK BY
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
This is incorrect. All Windows function must have an OVER() clause. The Partition By Clause CAN be used, however, it is not mandatory. If the Partition By Clause is omitted, the entire result set it treated as a single window partition.
0
0
how sure you are
0
1
Very sure he are
0
0
The answer should be OVER() clause.
0
0
OVER()
0
0