Posts Tagged: find nth salary

Find Nth highest salary using Dense_rank function in sql

In this article we learn how to find nth highest salary using Dense_Rank function is sql. Let’s create a table and name it table1. CREATE TABLE [table1]( [id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](30) NULL, [Salary] [int] NULL, [DepId] [int]… Continue Reading →