Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 130589 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
Define sdlc in testing.
Tell us how can you find if an element is displayed on the screen?
What are the pre-requisites to start automation testing?
can any one tell me the examples of white box testing
What kinds of annotations are used in testng?
List of Test Management Tools??Is Quality Center Test Management tools
What is the major difference between Functional test, Acceptance test, Usability test and performance test. With special reference to automotive domain
Explain what sikuli is?
What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain
8. How we test web based application
What are the types of the framework used in software automation testing?
Anyone aware of Test Runner (ETL Automation Testing tool) if so please help me with material in keerthi.smile14@gmail.com
What is a framework and what are the frameworks available in rc?
What is functional and regression testing?
What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...
