Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up

Which window functions retrieve values from previous or subsequent rows?

  1. A LAG and LEAD
  2. B FIRST and LAST
  3. C PREV and NEXT
  4. 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.

All Data MCQs

Login to manage your account

Please enter a valid email address.
Forgot Password?
Please enter a valid password.
OR

Don't have an account yet? Sign up as