how to select second mauximum value in a given table under salary column
Answer Posted / utkal
Select distinct(E1.Salary) from EMPLOYEE E1 where 2 =
(Select Count(distinct(E2.Salary)) from Employe E2 where
E1.Salary <= E2.Salary).
Here n=2,
Similarily we can find the 5th highest salary etc...
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to use "in out" parameter properly?
how to handle exceptions in post production
What is Virtual Private Database in Oracle?
Explain about achiever in sql?
Give the different types of rollback segments.
How to use subqueries in the from clause in oracle?
What is a data dictionary and how can it be created?
Write a syntax for update query in oracle?
How to download oracle database 10g xe?
How to specify default values in insert statement using oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is merge statement used for?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to retrieve data from an cursor to a record?