Write a query to find second highest salary of an employee.
- 72 Answers
- 109329 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / shyam
select max(salary) as '2nd Highest Salary'
from Employee a
where 2<=(select count(*) from Currencies b where a.salary
<= b.salary);
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
why we cannot apply check points in compile modules?
What are the main attributes of test automation?
What is junit? And what is junit annotation?
What type of scenarios can be automated?
How software testing is handled?
How do you select which automation tool is best suited for you?
Tell us how do you get the width of the textbox?
Tell me what are the different types of navigation commands?
Hi vishal, Thanks for your reply... But i am not using Mozilla fire fox.. I am using IE 7.. Could you suggest me in this case.. I have tried with Rational tools which i am getting some installation problem and netvantage..tool....which i felt i can't write script for that.. please guide me in this..
Does automation testing have any disadvantages?
what r the diffence between QTP 8.2 & QTP9.0?
did anybody take online training from Mind Q systems hyderabad? please share your experience. thanks
how to write ciertification in QTP?
what we have done after display the result in openSTA result pane.in the sense that how we send the report,what we send in report,how to know that where is error.quickly tell me the answer...please
Does every software project need testers?
