Nth Highest Salary

Create table #tblEmployee (Id int, [Name] varchar(100), City varchar(100), Salary decimal (10,3)) Insert into #tblEmployee values(1, ‘Prakash Rathod’, ‘Gandhinagar’, 100000) Insert into #tblEmployee values(2, ‘Salman Khan’, ‘Mumbai’, 100000) Insert into #tblEmployee values(3, ‘Aamir Khan’, ‘Mumbai’, 90000)…

Read More