Difference Between ROW_NUMBER, RANK, and DENSE_RANK In SQL Server

        Select Salary, 

ROW_NUMBER() over (partition by salary order by salary asc) as Rownum,

Dense_rank() over (order by salary desc) DenseRankId,

Rank() over (order by salary desc) RankId

from Employee