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

what is diffrent beatween localprinter and networkprinter

1740

What is the .net class that allows the retrieval of a data element using a unique key?

995

What is .net mobile automatic paging? : Microsoft dot net mobile

973

What are the new features of .net 2.0?

954

Explain the components required to develop mobile applications with .net mobile? : Microsoft dot net mobile

896

What is a clickonce application?

910

What is the problem with .net generics?

1056

How resource files are used in .net?

1018

question related to table havi colspan and row span

2246

Define cache? : Dot net architecture

931

What is the purpose of cache? How is it used? : Dot net architecture

870

how can we achieve language interoperability through CLS? How MSIL works?

1060

What is textview control of .net mobile? : Microsoft dot net mobile

988

What is .net mobile utility controls. : Microsoft dot net mobile

960

What is .net mobile images control. : Microsoft dot net mobile

912