select max(Salary)from employee where Salary not in (select max(Salary)fro

how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?

Question Posted / sathish

11 Answers
15618 Views
GeoTechnology, Wipro, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

Explain about validation?

985

What is .net mobile lists. : Microsoft dot net mobile

933

how to create applications by using Visual Studio 2012?

947

what is the difference between running an application with and without debugger?

2078

Can you Explain element .net mobile with example? : Microsoft dot net mobile

927

Explain COM with example?

931

Do you know textbox and textview controls of .net mobile? : Microsoft dot net mobile

1013

Use of Enable view state ? if turn off what happen ?

4455

Can you explain server controls in atlas?

958

Explain the Lapsed Listener problem in .net

1155

Explain cache memory? : .NET Architecture

967

What is Object Caching in Visual Studio 2010?

981

Explain How to improve the cache performance? : Dot net architecture

904

What is cookie less session?

1000

I can't be bothered with cas. Can I turn it off?

910