Write a query to find second highest salary of an employee.
Answer Posted / aarti
select * from employees
where salary = (select mnin(salary)from (select salary from
employees where rownum <= 2 order by salary DESC)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the drawbacks of test automation?
What are the main differences between Loadrunner and QTP tools? Describe briefly a "real world" scenario that would make you use the first one versus the other? Thank you for your answers....
In general, how do you see automation fitting into the overall process of testing?
Tell us how can you find if an element is displayed on the screen?
Tell me how could ajax controls be handled in webdriver?
Anyone aware of Test Runner (ETL Automation Testing tool) if so please help me with material in keerthi.smile14@gmail.com
What is meant by the automation framework?
if i want to use different values in datatable with each iteration of for loop what would i do ??/
What is the major difference between Functional test, Acceptance test, Usability test and performance test. With special reference to automotive domain
Tell us what is the alternate way to click on login button?
What is test automation or automation testing?
Tell me what criteria do you consider for automating a test?
Tell us how can you create html test report from your test script?
Any one suggest me for Free ware (Opensource) Automation tool for regression testing.
How would you test your own element locator?