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
How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.
What are the risks associated in automation testing?
how to re-install QTP 11.0 trial version
What are the most popular tools for automation testing?
What is an automation testing framework?
Tell me the fundamental difference between xpath and css selector?
hi every one this is ashok pls any one give answer me pls question is while testing with selenium after giving id user name and password , the inbox will be open , how to handle this one
Hi vishal, Thanks for your reply... But i am not using Mozilla fire fox.. I am using IE 7.. Could you suggest me in this case.. I have tried with Rational tools which i am getting some installation problem and netvantage..tool....which i felt i can't write script for that.. please guide me in this..
What kind of tests would you automate?
On Test Complete I recorded some keyword test. while I'm running the batch test, if one test case failed, then how test complete skip the failed test case and again continue to run the test case? please provide some way to resolve this issue.
Tell us what methods of robot class do you know?
How can you create html test report from your test script?
On what factors can you map the success of automation testing?
VSTET (Visual Studio Team Edition for Testers) which is in TFS (Team Foundation Server) - In what way is VSTET better than QTP?
In what condition we cannot use automation testing for agile method ?