Write a query to find second highest salary of an employee.
- 72 Answers
- 109335 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
Is there any freeware tool for automation testing of mobile applications for BlackBerry and iPhone platforms ?
Tell me the fundamental difference between xpath and css selector?
Do you know when autoit is used?
Hi, I want to learn DataBase Testing. So please some document or path so that i can get some material on DataBase Testing concepts (preferably SQL Server 2000). Thanks in advance, Guru
Which test cases can be automated?
What are the attributes of a good framework?
all clients are using at once if any problem raise?
List of Test Management Tools??Is Quality Center Test Management tools
Once you identify the tool what would be your next steps?
What are the different types of an automation tool that you are aware of?
Tell me what kind of tests should not be automated?
Please explain what is a relative xpath?
How do you choose which automation tool is best for your specific scenario?
pls tell me any open source test case managment tool ? its urgent.also tell me any autmation testing tool also for functional testing?
Can you do without a framework?
