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 function always produces unique sequential numbers within a partition?

  1. A ROW_NUMBER()
  2. B RANK()
  3. C DENSE_RANK()
  4. D NTILE()
Answer

ROW_NUMBER()

RANK leaves gaps after ties and DENSE_RANK does not. ROW_NUMBER is the usual choice for picking the latest row per group.

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