how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
- 11 Answers
- 13289 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
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
What is .net viewstate?
server.transfer limitation ?
How do I know when my thread pool work item has completed?
What is biginteger and when would you use that?
Explain the race around condition? : .NET Architecture How can it be overcome? : .NET Architecture
4. Wcf- what Asych and Sych call and how that works
Explain domestic architecture artifacts? : Dot net architecture
State and explain about microsoft.net?
Define cache coherency? : Dot net architecture
what are the events for a form?
What is .net mobile images control. : Microsoft dot net mobile
How do I prevent concurrent access to my data?
Waht is Dot net Arcitecture
What is application frame host?
Explain the purpose of cache? How is it used? : Dot net architecture
