Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128360 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / saima
1.
SELECT * TOP 1 from
(Select Top 2 from employee Order By Salary desc)
order By salary desc
2.
SELECT * from
(Select Top 2 from employee Order By Salary desc)
where salary <max(salary).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is client side validation? Write a snippet.
What is an automation testing framework?
What are the types of framework used in software automation testing ?
What is a critical bug in a testing field?
Discuss the economics of automation and the role of metrics in testing.
What is self-referencing constraint in mainframe development?
5. What are the tests you are conducting through winrunner?
What are the important operations in database testing?
What is difference between selenium and QTP tools Which is best tool... Which is most used tool
What are the main attributes of test automation?
Currently I do not have any automation in place in my project, but now I want to implement automation, what would be my steps?
Can you achieve 100% automation?
Have you completed the cps exam? Which one?
What type of scenarios can be automated?
why should we choose VSTET(Visual Studio Team Edition for Testers) and not QTP?pleas give me the reasons for "WHY" we have web and client server app, supports power builder and on windows OS so this is the background of tech and envir things we have and now VSTET is good to use or not? if "NO" then tell me why
