Write a query to find second highest salary of an employee.
Answer Posted / amit rajput
Select Min(NetAmount) from (Select Distinct Top 9 NetAmount
from vw_im order by NetAmount desc) a
This will give you 9th highest Salary
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which test cases can be automated?
what is GDC
how to re-install QTP 11.0 trial version
Tell us how can you find if an element is displayed on the screen?
Tell me what is intellij?
explain add in manager and virtual object wizard in winrunner
did anybody take online training from Mind Q systems hyderabad? please share your experience. thanksĀ
What are the drawbacks of test automation?
What is self-referencing constraint in mainframe development?
1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?
Tell us what you know about table-driven testing?
When will you automate a test?
When you will not automate testing?
What is functional and regression testing?
How do you decide which tool you have to use?