Ranking functions and usage scenarios in SQL Server

1.RowNumber() Over (oder by ...) Use when you need to sort a table for a discontinuous ID

2.row_number () Over (PARTITION by ...... ...) When you need to partition a table first, and then sort operations within a partition, use the

3.RANK() over [order by ...] when you need to sort a field with the same name (regardless of side-by-side)

4.Dense_rank() over (order by ...) (ditto, but consider a side position)

5.NTILE(the order by ...) divides the data table into 30 groups, ensuring that each group of data is close to the same number of bars

Ranking functions and usage scenarios in SQL Server