Write a query to find second highest salary of an employee.
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
how to write ciertification in QTP?
Give some examples for test management tools?
Do you know what is the purpose of creating a reference variable- 'driver' of type webdriver instead of directly creating a firefoxdriver object or any other driver's reference in the statement webdriver driver = new firefoxdriver();?
It is a 30 days project & the client is in Singapur and we have to submit daily report regarding 1) What are the completed works, 2) What are the Pending Works ,3) Work planed for next day. You are free to assume regarding the project. can anybody help me to write an email to the client or Senior person who is staying in abroad
Can you explain data-driven testing?
Do you know the difference between close and quit command?
What are the steps involved in the automation process ?
pls tell me any open source test case managment tool ? its urgent.also tell me any autmation testing tool also for functional testing?
What are the differences between open source tools, vendor tools, and in-house tools?
what is dynamic window and dynamic model ? (worksoft automation tool)
Bug report formate in bugzilla
can any one tell me the examples of white box testing
what is nTier Architecture understanding what is Microsoft ASP.net, ASP and SQL understanding what is Web Application and eCommerce application understanding what is Unit, System, Regression, FAT testing ? Test Automation and Test Script Authoring
Tell me an example of the languages supported by webdriver?
Do you know when autoit is used?