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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Session State and can i store desirialized object in state server, if yes how and if not why.

1348


Can you explain atlasuiglitz library?

525


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

603


What is the use of web.config?

608


What is the purpose of hard disk? : Dot net architecture

489






What is .net mobile utility controls. Explain with an example? : Microsoft dot net mobile

466


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

491


When do I need to use gc.keepalive?

646


Explain about httpruntime.cach.get(); method?

569


How do you handle this COM components developed in other programming languages in .NET?

578


What is a virtual memory? : Dot net architecture

533


Explain how to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile

500


Can you explain server controls in atlas?

536


What is the purpose of cache? : Dot net architecture

534


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

463