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 / sathish
select max(Salary)from employee where Salary not in (select
max(Salary)from employee )
select min(Salary)from employee where Salary not in (select
min(Salary)from employee )
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain difference between machine config vs. Web config : Dot net architecture
What is new in the .net 2.0 class library?
Explain the race around condition? : .NET Architecture How can it be overcome? : .NET Architecture
What are bindings?
how to set the startup position of the form?
What re interop services?
How do I stop a thread?
How cache is used? : Dot net architecture
What is a clickonce application?
Explain cache memory? : .NET Architecture
Explain about microsoft visual studio?
What is .net mobile lists. Explain with an example? : Microsoft dot net mobile
what is the difference between master page and content page?
Explain the purpose of cache? How is it used? : Dot net architecture
HttpHendler and HttpModules