Write a query to find second highest salary of an employee.
Answer Posted / bhaskar reddy thamma
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Write a short compiled module which selects random numbers. and what function is used to call your customized compiled module?
Name some of the commonly used automation testing tools that are used for non-functional automation.
Tell us how could you explain the main difference between webdriver and rc?
Tell us what automation tools could be used for post-release validation with continuous integration?
Hello, Is there any source from which i can get any live tutorial or trial of Automation tools?? Also i have a query that is there any certification course or exam available for Automation tools QTP and QC?
What are the important operations in database testing?
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....
IS DATA INTEGRITY TESTING AND INTEGRATION TESTING ONE AND THE SAME?IF DIFF CAN U SPECIFY THE DIFFERENCES
what is the dictionary objects in QTP? and what is method of vb script using virtual object wizard........
What is hybrid automation?
How to check if an element is visible on the page?
WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT
What is javascriptexecutor and in which cases javascriptexecutor will help in selenium automation?
What is the Differnce between Client/Server Testing and Web Based Testing?
Do you know what is the purpose of deselectall() method?