Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128812 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / krishna kishore
SELECT TOP 1 Salary FROM Employee WHERE Salary IN
(SELECT TOP 2 Salary FROM Employee ORDER BY Salary DESC)
I think this would be the simplest way and high performance
query.
waiting for the comments !!!
| Is This Answer Correct ? | 7 Yes | 11 No |
Post New Answer View All Answers
can anyone suggest me any low cost tool that can support both Manual and Automation testing ?
Do you know what is a data-driven framework?
How did you use automating testing tools in your job?
What is the different between GUI map and GUI map files?
What is extreme programming and what has it got to do with testing?
Explain what is a relative xpath?
What is vendor tool and give examples?
Do you know when autoit is used?
How to decide the tool that one should use for automation testing in their projects?
suggest me the free online books on software testing?
Please explain how to perform load-testing?
how to know whether the user information or any other information which is entered in to the web is storing in secured place or non secured place?
Tell me how a text written in a text field could be cleared?
Tell me what is the testng.xml file used for?
What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain
