Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126076 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
what is nTier Architecture understanding what is Microsoft ASP.net, ASP and SQL understanding what is Web Application and eCommerce application understanding what is Unit, System, Regression, FAT testing ? Test Automation and Test Script Authoring
Differentiate between hdam and hidam database?
What is the difference between close and quit command?
Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines
How can you create html test report from your test script?
Mention a few good practices while performing automation testing.
Tell me which web driver implementation is the fastest?
In what condition we cannot use automation testing for the agile method?
We have a testing assignment that is time-driven. Do you think automated tests are the best solution?
8. How we test web based application
Tell us what is the difference between getwindowhandles() and getwindowhandle()?
WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT
What java api is required for generating pdf reports?
What are the different types of scripting techniques for automation testing?
what is dynamic window and dynamic model ? (worksoft automation tool)
