Write a query to find second highest salary of an employee.
- 72 Answers
- 108847 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
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
Tell us how can you create html test report from your test script?
How to login into any site if it's showing any authentication pop-up for username and password?
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 keyword driven frame work..where Driver Script is locate? is there any inbuilt script for driver script?who writes the driver script?how to call it any body can tell me with an example...like(yahoo login,inbox, logout).
What are the disadvantages of Hybrid framework
Tell me what kind of tests should not be automated?
What is junit? And what is junit annotation?
Explain me what is the difference between setspeed() and sleep() methods?
List some advantages and disadvantages of automation testing.
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 are the limitations of automating software testing?
Explain me what is testng and why is it better than junit?
What is test tool?
what we have done after display the result in openSTA result pane.in the sense that how we send the report,what we send in report,how to know that where is error.quickly tell me the answer...please
Hi All! Am new to Selenium and would really appreciate your help writing test cases for the following scenario: 1. Manually create 2 logins User A and User B on say, orkut.com or facebook.com. 2. Have User A invite User B as a friend. 3. Have User B accept the friend request. 4. Have User A post a comment on his own profile. 5. Have User B post a reply to that comment. 6. Each User logs out of his respective account. 7. Do not use Selenium IDE. 8. Use Selenium RC and Java.
