ROW_NUMBER

Concepts: sqlRowNumber

Basic ROW_NUMBER Every employee gets a unique number from 1 to 6, ordered by salary from highest to lowest. Carol earns the most so she gets position 1. Dave earns the least so he gets position 6. No two rows ever share the same number. ROW_NUMBER + PARTITION BY Multiple ORDER BY Columns Handling NULLs in ORDER BY ROW_NUMBER Applications Dedup with ROW_NUMBER Which approach would you use to find the most recent signup per user?