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
What is MS chart control in visual studio?
Does .NET runtime offer Deterministic Destruction or not?
What is .net mobile input validation. : Microsoft dot net mobile
What is cache coherency and how is it eliminated? : Dot net architecture
Explain about httpruntime.cach.get(); method?
What is difference between Desktop, Client Server & Web based applications?
Can you explain server controls in atlas?
What is IL code, CLR, CTS, GAC & GC?
What is .net mobile forms? : Microsoft dot net mobile
What actually happes when you add a something to arraylistcollection ?
Explain dma? : Dot net architecture
What is a virtual memory? : Dot net architecture
How will you do windows authentication and what is the namespace?
Explain about cookie less session state? : .NET Architecture
Define pipelining? : Dot net architecture