Write a query to find second highest salary of an employee.
- 72 Answers
- 109238 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
Which protocol cam be used to makw jdbc connection woth loadrunner
What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain
Tell us what is the difference between @factory and @dataprovider annotation?
What are the phases in automation testing life cycle?
Do you know when autoit is used?
1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?
Does automation testing have any disadvantages?
What are the points that are covered while planning phase of automation ?
what is critical test case ? please give an example .
how to import specifically 2nd column elements to runtime datatable in excel sheet if it contains 3 columns
how to test an webbased application?
Differentiate between hdam and hidam database?
What is a framework and what are the frameworks available in rc?
What are the 5 common software development problems solutions?
What is hybrid automation?
