Write a query to find second highest salary of an employee.
Answer Posted / sup
SELECT TOP 1 salaryamount
FROM (
SELECT DISTINCT TOP 3 salaryamount
FROM mstsalary
ORDER BY salaryamount DESC) a
ORDER BY salaryamount
--sup--
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can i count the no of edit field in a page and fill the multiple edit field
Manually in a page 10 check boxes is there.so 5 check box "on" and 5 check box "off" so using descriptive program how to know how many "on" and how many "off" plz help me this question answer?
Do you know when autoit is used?
suggest me the free online books on software testing?
Tell me what is a keyword-driven framework?
Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines
What should you do after finding a bug?
What is client side validation? Write a snippet.
What are the steps to perform Load and Stress testing on a Website? What resources do I need to do this? Please advise. Thanks in advance.
How could you explain the main difference between webdriver and rc?
Can you achieve 100% automation?
Is ui level testing possible?
What are the primary features of good automation tool ?
What are the differences between open source tools, vendor tools, and in-house tools?
Which is the best place to learn Loadrunner performance testing in hyderabad ?