Question
What does FIRST_VALUE return in a window partition?
Select an option. Your answer will be checked instantly.
Correct Answer: A. The expression value from the first row of the defined ordered frame
Explanation:
FIRST_VALUE follows the window ordering and frame definition.
It can repeat a baseline value across rows for comparison.
Leave a Reply