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
What is an interrupt? : Dot net architecture
Explain the race around condition? : Dot net architecture
What is msil, and why should my developers need an appreciation of it if at all?
What is the difference between an application and a program?
What is .net mobile lists. Explain with an example? : Microsoft dot net mobile
Can I create my own context attributes?
State the different levels of exceptional safety?
How does .net mobile work? : Microsoft dot net mobile
Explain dma? : Dot net architecture
How do you handle this COM components developed in other programming languages in .NET?
what is diffrent beatween localprinter and networkprinter
What is the cli? Is it the same as the clr?
Explain the types of memory management? : Dot net architecture
how to change row background color in gridview
What is .net mobile utility controls. : Microsoft dot net mobile