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

What is MS chart control in visual studio?

791


Does .NET runtime offer Deterministic Destruction or not?

670


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

614


What is cache coherency and how is it eliminated? : Dot net architecture

593


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

668






What is difference between Desktop, Client Server & Web based applications?

626


Can you explain server controls in atlas?

611


What is IL code, CLR, CTS, GAC & GC?

683


What is .net mobile forms? : Microsoft dot net mobile

607


What actually happes when you add a something to arraylistcollection ?

589


Explain dma? : Dot net architecture

650


What is a virtual memory? : Dot net architecture

614


How will you do windows authentication and what is the namespace?

650


Explain about cookie less session state? : .NET Architecture

642


Define pipelining? : Dot net architecture

708