ROW_NUMBER() in #SQL #sqlserver #database #dba #data #dataengineering #dataanalytics #datascience

How often do you use this one ?

ROW_NUMBER () - Numbers the output of a result set. More specifically, returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.
ROW_NUMBER and RANK are similar. ROW_NUMBER numbers all rows sequentially (for example 1, 2, 3, 4, 5). RANK provides the same numeric value for ties (for example 1, 2, 2, 4, 5).