Write a query to find second highest salary of an employee.
Answer Posted / ajay
SELECT * FROM employee WHERE salary=(SELECT MAX(salary) FROM employee WHERE employee.salary <
(SELECT MAX(salary) FROM employee))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which protocol cam be used to makw jdbc connection woth loadrunner
How to decide the tool that one should use for automation testing in their projects?
what is critical test case ? please give an example .
How do you plan test automation?
Tell me what type of scenarios can be automated?
Tell us the line of code webdriver driver = new firefoxdriver();.?
Tell me how could ajax controls be handled in webdriver?
what is aom and how to add object repository? i am very new to QTP please help me
What are different coverages in function testing?
What are the primary features of good automation tool ?
Simplify the term defect severity.
What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain
What is a framework for automation testing?
List the five essential types of test steps?
how to use regular expression in Test Complete Functional tool