Write a query to find second highest salary of an employee.
Answer Posted / hardit
select TOP 1[salary]
from(
select distinct TOP 2[salary]
from empTable
order by salary desc
) a
order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Where do we get the QTP and Load runner softwares CDs ( Original ) in chennai
Give some examples for performance test tools?
Tell us how to select a value in a dropdown?
Explain me what is a framework and what are the frameworks available in rc?
Types of F/w in Automation
Why do you prefer selenium automation tool?
Write a short compiled module which selects random numbers?
Explain me how do you send enter/tab keys in webdriver?
What issues come up in test automation, and how do you manage them?
How do you choose which automation tool is best for your specific scenario?
hello frnds this pooja i hav started working on selenium with java ecllipse frnds could u tell me how to handle popup windows and security alerts i m jst trying and couldn't do anything plz help
What are the things that one should consider for selecting a project for test automation? For example, stability, etc.
Please explain what is a relative xpath?
why should we choose VSTET(Visual Studio Team Edition for Testers) and not QTP?pleas give me the reasons for "WHY" we have web and client server app, supports power builder and on windows OS so this is the background of tech and envir things we have and now VSTET is good to use or not? if "NO" then tell me why
How to integrate Rational functional Tester with Rational Quality manager. Can anyone provide the details steps giving explaination with examples.