Write a query to find second highest salary of an employee.
- 72 Answers
- 108795 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / kapil deep
SELECT * FROM (SELECT * FROM emp_t WHERE ROWNUM < 3 ORDER
BY salary) WHERE ROWNUM < 2
above query work fine for oracle.
Taking 3 as N give u 3-1=2 i.e 2nd highest
4-1=3 gives u 3rd highest
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Why do you want to keep this kind of information in a separate file and not directly in the code?
How do you select which automation tool is best suited for you?
How the object properties will be recognised by the tool If the functions/ statements are written manually?
What is a ‘test plan’? What is a ‘test case’?
wat would be the -ve test case for search where u can brak it ,tell dnt tell abt spl characters insertion ,boundary values chk.
What is data - driven automation?
What is in-house tool?
When will you not automate testing?
What is test driven development?
What steps are needed in developing and running a software test?
Explain me what are the main advantages of automation testing?
Do you know the difference between close and quit command?
how to use regular expression in Test Complete Functional tool
Tell us what is the alternate way to click on login button?
How can you create html test report from your test script?
