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
- 16064 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
How can we integrate atlas with web services?
What is msil, and why should my developers need an appreciation of it if at all?
What is an asssembly qualified name? Is it a filename? How is it different?
What is the difference between machine config vs. Web config : Dot net architecture
How can I write my own .NET host?
Explain the process of gc?
What are the main Tools to develop .Net Application?
Explain the use of virtual, sealed, override, and abstract.
question related to table havi colspan and row span
Explain the purpose of cache? : Dot net architecture
how to use custom field validation
Explain Intermediate Language?
Explain how cache is used? : Dot net architecture
What is the difference between absolute expiration and sliding-time expiration?
Define the mesi? : Dot net architecture
