Question
Which window function assigns a unique sequential number within each ordered partition?
Select an option. Your answer will be checked instantly.
Correct Answer: D. ROW_NUMBER
Explanation:
ROW_NUMBER gives every row a different sequence value according to the specified order.
Tied sort values still receive different row numbers.
Leave a Reply