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

To find Second highest salary

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
- No comments:
Labels:
Subscribe to: Posts (Atom)

Implementing OAuth validation in a Web API

 I mplementing OAuth validation in a Web API Implementing OAuth validation in a Web API using C# typically involves several key steps to sec...