Write a query to find second highest salary of an employee.
Answer Posted / raaghav
Try this query
===================
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
where n > 1 '(n is always greater than one)
E.g.:-
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 6 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
notice the distinction between data driven testing and retesting?
I am surekha new commer for this site? I have some doubt's pls clarify it..... I finished my B.tech and S/w Testing Course Now iam searching for a job in Testing, I did not have any experience in real time projects. Any body can send me the sample Testcases,Srs,Matrix for Banking,ERP Projects etc.Here is my email id surekhai@yahoo.com
What are different coverages in function testing?
How automation process is carried out?
Tell us can we find all links on a web page?
how to map requirements& test cases in quality center ???
Tell me how can we find the value of different attributes like name, class, value of an element?
Tell us how could you explain the main difference between webdriver and rc?
I want a code for a following item in TSL Language. Look up a person in database, If not found, add person to the database.
Do you know what is a xpath?
How to decide the tool that one should use for automation testing in their projects?
HOW CAN WINRUNNER AND TEST DIRECTOR CONNECTED TO THE DATABASE AND WHAT R THE OPTIONS?
Tell me how a text written in a text field could be cleared?
What are the frameworks available in rc?
Hi everyone, Are you looking for "worksoft certify" automation tool training online? We have experienced corporate Worksoft certify trainers. We also provide support Worksoft certify automation issues. Please contact us Automationsolutions@yahoo.com