Write a query to find second highest salary of an employee.
- 72 Answers
- 108779 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / vittal
select max(sal)from emp e1 where 2<=(select count(*) from
emp e2 where e1.sal <= e2.sal);
| Is This Answer Correct ? | 66 Yes | 38 No |
Post New Answer View All Answers
Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(
What are the frameworks available in rc?
What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...
What is the difference between continue and next sentence?
Can you explain me what is object repository?
What is a xpath?
Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(
Can the activities of test case design be automated?
What is open source tool and give example?
What is tsl?
what types of documents we need to write the nonfuntional test scripts?
What is an automated test script?
Can you explain data-driven testing?
What are the advantages of automation testing?
Tell us how can you create html test report from your test script?
