Write a query to find second highest salary of an employee.
- 72 Answers
- 108730 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
What are the different types of locks in mainframe?
hi, I want to study TIA portla V11. where can I get online courses?
Do you know what is a data-driven framework?
What is the different between GUI map and GUI map files?
Tell us which package can be imported while working with webdriver?
What is junit annotation?
How do you plan test automation?
Explain me what kinds of annotations are used in testng?
1. How would you Test & then automate an antivirus application? 2. How would u test & automate windows screen saver? (expected: "test scenarios" & "test approch": points)
What are the pre-requisites to start automation testing?
how to test an webbased application?
Tell us the difference between assert and verify commands?
What are the different types of scripting techniques for automation testing?
Give some examples for test management tools?
Tell us how can you create html test report from your test script?
