Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15764 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
Explain the difference between primary & secondary storage device? : .NET Architecture
Explain difference between machine config vs. Web config? : .NET Architecture
How do I write to the application configuration file at runtime?
What is ILDASM ?
What's the difference between an application and a program?
4. Wcf- what Asych and Sych call and how that works
What is the importance of updatepanel control?
What are the options provived by vss to the user? how it will help us while delevoping application?
What happens to the winfx technologies?
Explain domestic architecture artifacts? : Dot net architecture
What is cache coherency? : Dot net architecture
Can you explain server controls in atlas?
Define pipelining? : Dot net architecture
What re interop services?
How to improve the cache performance? : Dot net architecture
