To find Second highest salary
select top 2 * from Trainee.dbo.Depart where Salary in(select top 1 Salary from Trainee.dbo.Depart)order by Salary DESC
Showing posts with label To find Second highest salary. Show all posts
Showing posts with label To find Second highest salary. Show all posts
9 September 2010
Subscribe to:
Posts (Atom)