Tag Archives: Rank() v/s Dense_Rank()

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 decide to solve this puzzle and thinking It will be sort out by Rank() function. There is one another function to […]