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
-
Labels:

No comments:

Post a Comment

Comments Welcome

Subscribe to: Post Comments (Atom)

Consistency level in Azure cosmos db

 Consistency level in Azure cosmos db Azure Cosmos DB offers five well-defined consistency levels to provide developers with the flexibility...