Write a query to find second highest salary of an employee.
- 72 Answers
- 108627 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / girase hitendrasing a.
select * from Employees where Salary in (select top 1
salary from (select distinct top 2 salary from employees
order by salary desc) order by salary asc)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Tell me what databases can test director reside on?
Do you know what is selenese?
what is the advantage and dis-advantages of using framework ?
What are the advantages of manual testing and automated testing?
Tell me how can you switch back from a frame?
what is critical test case ? please give an example .
Does every software project need testers?
Define sdlc in testing.
Tell me what are the different types of navigation commands?
What is difference between selenium and QTP tools Which is best tool... Which is most used tool
List down the primary features of a good automation tool?
Please name a couple of standard web function found in the function generator?
Can you explain me what is object repository?
Do you know what is the purpose of deselectall() method?
What you know about table-driven testing?
