Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 130591 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
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
IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?
Does automation testing have any disadvantages?
What is the purpose of getoptions() method?
What is meant by the automation framework?
How do you decide which tool you have to use?
Why automation testing?
Tell us what is the difference between getwindowhandles() and getwindowhandle()?
what is GDC
Can you achieve 100% automation?
HOW CAN WINRUNNER AND TEST DIRECTOR CONNECTED TO THE DATABASE AND WHAT R THE OPTIONS?
1. How would you Test & then automate an antivirus application? 2. How would u test & automate windows screen saver? (expected: "test scenarios" & "test approch": points)
How would you test your own element locator?
Please explain what is a relative xpath?
How many test cases have you automated per day?
Explain some disadvantages to manual software testing?
