Quick glance of different ranking functions that we can use in SQL Server -
Ranking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Ranking functions are nondeterministic.
SQL Server introduced four different ranking functions to rank the rows in partition or in general -
Example on different strategies to remove duplicate records in SQL server in a typical ETL OR OLTP type applications -
Thanks - D