find out the second highest salary?
Answer Posted / janmejaya
select top(1) * from employee where salary in (select
distinct top(2) salary from employee order by salary desc)
order by Salary
Above query is dynamic, if u want 3rd highest then just
change 2 to 3 , Please Try It
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to drop an index?
Is oracle the best database?
What is oracle used for?
What are the different types of failures that occur in Oracle database?
How to apply filtering criteria at group level in oracle?
How to use "in out" parameter properly?
How to display row numbers with the records?
What privilege is needed for a user to create indexes in oracle?
How to assign data of the deleted row to variables?
Is oracle an open source?
How to convert characters to numbers in oracle?
What happens to the current transaction if the session is killed?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is sequence?
How to delete a user account in oracle?