Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anilchandu
Select * from emp x where 2=(select count(distinct sal)
from emp y where x.sal<=y.sal)
where x,y are alias names.
If you want 3rd heighest salary then just replace 2 by 3
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to drop an index in oracle?
What are the advantages of oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is a initialization parameter file in oracle?
What is a sub query and what are the different types of subqueries?
What are the common oracle dba tasks?
How to run queries on external tables?
How to start a specific oracle instance?
How to shutdown your 10g xe server?
Difference between hot backup vs. Cold backup?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to import one table back from a dump file?
What are transaction isolation levels supported by oracle?
what is the difference between restoring and recovering?
How to do paging with oracle?
