To find the second highest salary from a table
select top 1 name,id from tbltest where name not in (select top 1 name from tbltest order by name desc) order by name desc
Same if you want to select the nth highest salary from a table
select top 1 name,id from tbltest where name not in (select top n name from tbltest order by name desc) order by name desc
select top 1 name,id from tbltest where name not in (select top 1 name from tbltest order by name desc) order by name desc
Same if you want to select the nth highest salary from a table
select top 1 name,id from tbltest where name not in (select top n name from tbltest order by name desc) order by name desc
No comments:
Post a Comment