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

Explain dma? : Dot net architecture

970

How to prevent my .NET DLL to be decompiled?

999

.Net Frame work arch?

1991

What does the term "green architecture" mean? : Dot net architecture

849

Why the config file might not be writable

1038

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

4404

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

925

how to delete the record using data reader

2413

Explain pipelining? : Dot net architecture

948

What is .net mobile input validation. : Microsoft dot net mobile

885

what are constructors and destructors?

2094

Explain difference between inprocess vs out process session state? : .NET Architecture

937

Whate are resource files? How are they used in .net?

855

How resource files are used in .net?

980

What is boxing and unboxing? Does it occure automaatically or you need to write code to box and unbox?

912