Write a query to find second highest salary of an employee.
- 72 Answers
- 109259 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
What type of scenarios can't be automated?
what is the difference between keyword driven frame work and data driven frame work.
What you know about table-driven testing?
Tell us how can we handle web-based pop-up?
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
Explain what is the hybrid framework?
Can we prioritize tests in Junit. What is the sequence of execution in Junit?
When will you not automate testing?
VSTET (Visual Studio Team Edition for Testers) which is in TFS (Team Foundation Server) - In what way is VSTET better than QTP?
When do you prefer manual testing over automation testing?
Have you completed the cps exam? Which one?
what is the dictionary objects in QTP? and what is method of vb script using virtual object wizard........
What are the 5 common software development problems solutions?
Can we do automation testing without a framework? If yes, then why do we need a framework?
How many test cases have you automated per day?
