Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 130544 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / sup
SELECT TOP 1 salaryamount
FROM (
SELECT DISTINCT TOP 3 salaryamount
FROM mstsalary
ORDER BY salaryamount DESC) a
ORDER BY salaryamount
--sup--
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
i have one answer from you that today the test cases are not stored in the database(SQL server 2005). But in automation testing where does the test case store? plz tell me... i have more confusion
WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?
How do select which automation testing tool is the best for you?
Which test cases can be automated?
hi, I want to study TIA portla V11. where can I get online courses?
Does every software project need testers?
Tell us what is the difference between getwindowhandles() and getwindowhandle()?
What is self-referencing constraint in mainframe development?
What is difference between selenium and QTP tools Which is best tool... Which is most used tool
What is the scripting standard while performing automation testing?
How does load testing work for websites?
What are the disadvantages of Hybrid framework
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..
List some advantages and disadvantages of automation testing.
Explain what sikuli is?
