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 / sudhir
1. 2nd highest salary=>
Select top 1 * from (select top 2 * from emo order by sal
desc) order by sal asc
2. 2nd lowest salary
Select top 1 * from (select top 2 * from emo order by sal
Asc) order by sal Desc
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can implement drag and drop using atlas?
Describe the advantages of writing a managed code application instead of unmanaged one. What is involved in certain piece of code being managed?
What is gui programming? : .NET Architecture
what are constructors and destructors?
where should I put this information then?
Explain the difference between state server and sqlserver : Dot net architecture
Difference between type constructor and instance constructor?
Differnce between managed code and unmanaged code ?
Can you explain control extenders?
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.
Define cache coherency and how is it eliminated? : Dot net architecture
Can I create my own permission set?
Explain the purpose of cache? : Dot net architecture
Is .net easier than java?
Explain how to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile