Write a query to find second highest salary of an employee.
- 72 Answers
- 108610 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / rajkumar mandala
select sal from
(select sal,(row_number() over (order by sal)) N from emp ) y where N= {value}
Replace {value} value with required highest value.
ie, 2 for 2nd highest
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
How did you use automating testing tools in your job?
What is the scripting standard while performing automation testing?
What are the types of the framework used in software automation testing?
Do you know what is the purpose of deselectall() method?
Tell me the fundamental difference between xpath and css selector?
How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.
What is test automation?
What are the pre-requisites to start automation testing?
How would you test your own element locator?
Any kind of test which you think should not be automated?
Is ui level testing possible?
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 is critical test case ? please give an example .
Tell us how to select a value in a dropdown?
what is aom and how to add object repository? i am very new to QTP please help me
