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
Session State and can i store desirialized object in state server, if yes how and if not why.
Can you explain atlasuiglitz library?
how can we achieve language interoperability through CLS? How MSIL works?
What is the use of web.config?
What is the purpose of hard disk? : Dot net architecture
What is .net mobile utility controls. Explain with an example? : Microsoft dot net mobile
What is .net mobile images control. : Microsoft dot net mobile
When do I need to use gc.keepalive?
Explain about httpruntime.cach.get(); method?
How do you handle this COM components developed in other programming languages in .NET?
What is a virtual memory? : Dot net architecture
Explain how to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile
Can you explain server controls in atlas?
What is the purpose of cache? : Dot net architecture
Explain the components required to develop mobile applications with .net mobile? : Microsoft dot net mobile