how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
Answer Posted / arrry.net
Select top 1 salary from tbl_registration where salary in
(SELECT TOP 2 salary from tbl_registration)
order by salary desc
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the .net class that allows the retrieval of a data element using a unique key?
Describe the Managed Execution Process in .NET?
Explain pipelining? : .NET Architecture
Session State and can i store desirialized object in state server, if yes how and if not why.
Explain cache memory? : Dot net architecture
The maximum report processing jobs limit configured by your system administrator has been reached.How I can Solve this problem when i using crystal report to load from my application.
difference between data reader and dataset
What is the purpose of Accordian in jquery? Where it can be used?
How does an appdomain get created?
Explain the race around condition? : .NET Architecture
Whats new features in Visual Studio 2012?
Explain .net mobile selectionlist control? : Microsoft dot net mobile
Explain about the base class library provided by microsoft.net?
Explain .net mobile events? : Microsoft dot net mobile
What is cookie less session?