Table: tbemployee
select empid, empname ,empsalary from (select empid,empname,empsalary, ROW_NUMBER() over (Order by empsalary desc) as salary_order from tbemployee
) DT
where DT.salary_order=3
click here for : First Highest salary
Finding the 3rd highest salary in SQL Server
select empid, empname ,empsalary from (select empid,empname,empsalary, ROW_NUMBER() over (Order by empsalary desc) as salary_order from tbemployee
) DT
where DT.salary_order=3
0 comments:
Post a Comment