Which window functions retrieve values from previous or subsequent rows?
- A LAG and LEAD
- B FIRST and LAST
- C PREV and NEXT
- D BEFORE and AFTER
Answer
LAG and LEAD
They calculate period-over-period change without a self-join, which is far clearer and usually faster.





