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
Can I create my own metadata attributes?
When do I need to use gc.keepalive?
What is Video Streaming in .net??
Explain the five stages in a dlx pipeline? : .NET Architecture
What is biginteger and when would you use that?
Explain the purpose of cache? How is it used? : .NET Architecture
What are the different pipelining hazards and how are they eliminated? : Dot net architecture
What does this do? Gacutil /l | find /i "corillian"
Explain a .net mobile example with details? : Microsoft dot net mobile
Explain about common language infrastructure?
Explain How to improve the cache performance? : Dot net architecture
Explain dma? : .NET Architecture
where should I put this information then?
How do I prevent concurrent access to my data?
What is the difference between an event and a delegate?