Which window function always produces unique sequential numbers within a partition?
- A ROW_NUMBER()
- B RANK()
- C DENSE_RANK()
- 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.





