Write a query to find second highest salary of an employee.
- 72 Answers
- 108629 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 rank() OVER (order by sal desc) sno ,sal from emp)
y
where sno= n
here
y : is the alias name for (select rank() OVER (order by sal
desc) sno ,sal from emp)
n : is the number ie if u want second highest sal then 'n'
value will be 2. for third highest n= 3...
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
explain add in manager and virtual object wizard in winrunner
Tell me how a text written in a text field could be cleared?
Explain what is the difference between findelement () and findelements ()?
Explain some disadvantages to manual software testing?
VSTET (Visual Studio Team Edition for Testers) which is in TFS (Team Foundation Server) - In what way is VSTET better than QTP?
Give some examples for test management tools?
What is javascriptexecutor and in which cases javascriptexecutor will help in selenium automation?
HOW DO YOU PERFORM SECURITY TESTING TO VERIFY FIREWALLS,PASWORD ENCRYPTOPNS ETC?
Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)
What are the different types of testing framework techniques?
Discuss the economics of automation and the role of metrics in testing.
WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT
What is the major difference between Functional test, Acceptance test, Usability test and performance test. With special reference to automotive domain
What is the process of Automation Testing?
Tell us what automation tools could be used for post-release validation with continuous integration?
