Write a query to find second highest salary of an employee.
Answer Posted / khurram
The Simplest, easy, Understandable solution is
select max(sal) from emp where
sal not in
(select distinct Top 1 sal from emp order by sal desc)
Go Check Out for yourself
[replace "top 1" by "top 2" to get 3rd highest sal]
[replace "top 1" by "top 3" to get 4th highest sal] so on..
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to check if an element is visible on the page?
Tell me which web driver implementation is the fastest?
What is the different between GUI map and GUI map files?
What is modular automation?
List the five essential types of test steps?
Tell us which package can be imported while working with webdriver?
What are the different types of scripting techniques for automation testing?
Explain about basics of rational robot - ibm test automation tool?
Explain me how to check if an element is visible on the page?
How will you automate basic “login” functionality test cases for an application?
why we cannot apply check points in compile modules?
What are the pre-requisites to start automation testing?
4. How we implement Winrunner,in our project?
Why do you prefer selenium automation tool?
can any one please tell me QTP 9.2 supports which version of IE and Mozilla firefox.