Write a query to find second highest salary of an employee.
Answer Posted / parul
SELECT MAX(A.SALARY) AS MSAL
FROM EMP A
WHERE
(SELECT MAX(B.SALARY) AS M1SAL
FROM EMP B) < MSAL
AND A.SALARY = B.SALARY;
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...
Tell us how to login into any site if it's showing any authentication pop-up for username and password?
What is junit annotation?
hi i would like to know is there any training institue for Calabash,robotium and ui automator in hyderabad...urgent
Mention a few good practices while performing automation testing.
We have a testing assignment that is time-driven. Do you think automated tests are the best solution?
can any one please tell me QTP 9.2 supports which version of IE and Mozilla firefox.
Simplify the term defect severity.
How do i startup with Remedy testing tool. Couldnot able to find any links for startup. Please help me to startup with this remedy tool.
Explain me what is the difference between setspeed() and sleep() methods?
In general, how do you see automation fitting into the overall process of testing?
Tell me how could the web element attributes be inspected in order to use them in different locators?
What are the advantages of manual testing and automated testing?
Tell us what is junit? And what is junit annotation?
how to test an webbased application?