select max(amt)as amt from EmployeePaymentDetails where amt< (select ma

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 / deepak

Answer Posted / deepak

select max(amt)as amt from EmployeePaymentDetails where amt<
(select max(amt)as amt from EmployeePaymentDetails)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to improve the cache performance? : Dot net architecture

943

Explain the race around condition? : .NET Architecture

1023

Explain COM with example?

965

What is password attribute of the textbox control of .net mobile? : Microsoft dot net mobile

941

What is biginteger and when would you use that?

952

State and explain about microsoft.net?

964

How do I write to the application configuration file at runtime?

1009

What is one way operation?

977

Explain the race around condition? : .NET Architecture How can it be overcome? : .NET Architecture

933

What is the difference between absolute expiration and sliding-time expiration?

1047

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

958

Explain different pipelining hazards? : Dot net architecture

992

What actually happes when you add a something to arraylistcollection ?

961

Explain dma? : .NET Architecture

962

How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts

1077