Question
Which analytic function returns a value from a preceding row in the ordered window?
Select an option. Your answer will be checked instantly.
Correct Answer: C. LAG
Explanation:
LAG accesses an earlier row without a self-join.
It is useful for period-over-period differences and change detection.
Leave a Reply