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 the method while we are using adapter and dataset ?
how to use custom field validation
Define cache? : Dot net architecture
What is the purpose of cache? How is it used? : Dot net architecture
question related to table havi colspan and row span
When do I need to use gc.keepalive?
Explain the five stages in a dlx pipeline? : Dot net architecture
What do you know about machine.config file ?
Explain .net mobile automatic paging? : Microsoft dot net mobile
What is application frame host?
Explain the number or character entered through keyboard gets converted to equivalent ascii code & it get stored on ram in the binary form.
What is the mesi? : .NET Architecture
Explain the purpose of cache? How is it used? : Dot net architecture
Define a managed code? : Dot net architecture
What actually happes when you add a something to arraylistcollection ?