Ranking

0001-01-01

ROW_NUMBER, RANK, and DENSE_RANK: Three Ways to Order Rows

Three ranking functions, three different answers to ties. Pick the one that matches what your data actually means.