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
Elaborate the fields in bug report in automated testing
Do you know how to check if a button is enabled on the page?
Tell me what criteria do you consider for automating a test?
I want to test a mobile software by an automation tool which is a IP telephony based software designed for both ios and android phone, basically this apps is develop for make call though few low cost audio codecs from Aircraft to Ground and Ground to Aircraft so anyone can suggest me which testing tool we can use for it
What is extreme programming and what has it got to do with testing?
What all different approaches can be used for designing an automation solution?
I am new to Test Complete ,can any one suggest me the steps to create/Record and replay a test in Test complete 6....
What is a framework for automation testing?
Can you achieve 100% automation?
Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.
Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)
Simplify the term defect severity.
Tell us how can you create html test report from your test script?
Why do you prefer selenium automation tool?
how can i count the no of edit field in a page and fill the multiple edit field