Write a query to find second highest salary of an employee.
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
Explain how to perform load-testing?
Tell me which web driver implementation is the fastest?
How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.
How could the web element attributes be inspected in order to use them in different locators?
How to login into any site if it's showing any authentication pop-up for username and password?
How will you automate basic “login” functionality test cases for an application?
Can we do automation testing without a framework? If yes, then why do we need a framework?
can anyone suggest me any low cost tool that can support both Manual and Automation testing ?
Tell me what is intellij?
Name the frameworks that are used in software automation testing?
What steps are needed in developing and running a software test?
Can we prioritize tests in Junit. What is the sequence of execution in Junit?
is anybody suggest me which one is the best testing institute in ameerpet hydrabad
Give some examples of priority – severity defect levels.
Tell us how can you find if an element is displayed on the screen?