ROWNUMBER() is a window function that assigns a unique sequential number to each row in a result set according to an ORDER BY inside the OVER clause. It is commonly used for pagination, top-N queries, deduplication, and deterministic row labeling. Handling Ties Because ROWNUMBER() always assigns unique numbers, tied values still receive different positions. If two employees have the same salary, one still gets row 1 and the other row 2 depending on the ordering rules. That makes it ideal when you need a strict sequence rather than shared ranks. Window Functions Concept Window functions do not collapse rows the way GROUP BY does. They let you calculate values across a logical window while preserving every original row in the result. That distinction is central to advanced analytical SQL.
Key Takeaways
ROWNUMBER() assigns a unique sequence based on the ORDER BY clause.
Useful for pagination, top-N queries, and deduplication patterns.
Tied values still get different row numbers.
Window functions preserve row detail instead of grouping rows away.