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) Insert into #tblEmployee values(4, ‘Katrina Kaif’, ‘Mumbai’, 80000) Insert into #tblEmployee values(5, ‘Rashmi Bansal’, ‘Indor’, 95500) Insert into #tblEmployee …
Nth Highest Salary
