Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128744 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
what is critical test case ? please give an example .
Elaborate the scripting standard while executing testing
Why automation testing?
Tell me what is the purpose of getoptions() method?
How would you test your own element locator?
When will you automate a test?
What are the 5 common software development problems solutions?
How do you choose which automation tool is best for your specific scenario?
List the five essential types of test steps?
Hello Friends, I am Looking for the Load runner-Performance testing institute in HYD. I see most of them in this site are suggesting for TS Technologies as best institute for PT load runner. We you pls suggest me, Does this institute offers good coaching on Weekend Sessions/Batches? Does it covers all the course contents in these session? Please help me on this guys..
WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT
is anybody suggest me which one is the best testing institute in ameerpet hydrabad
In what condition we cannot use automation testing for the agile method?
What are the advantages of test automation?
How to check if an element is visible on the page?
