What is the purpose of `ROW_NUMBER() OVER (PARTITION BY col ORDER BY col2)` in deduplication?

Question

Advanced SQL Developer — Medium

What is the purpose of `ROW_NUMBER() OVER (PARTITION BY col ORDER BY col2)` in deduplication?

Accepted Answer

The purpose of `ROW_NUMBER() OVER (PARTITION BY col ORDER BY col2)` in deduplication is to assign a sequential number to each row within each partition. This is used for deduplication by selecting only rows where ROW_NUMBER() = 1 to keep one row per group based on a specified ordering criterion.