Rank() v/s Dense_Rank()

No Image

SQL Server Rank() v/s Dense_rank()

Yesterday night I was searching about SQL Server system functions and got a nice puzzle of SQL Server. The puzzle likes to find out second highest salary of each department and tie salary should also count. Finally…