find out the third highest salary?
Answer Posted / swaminathan
select *
from (select distinct sal from emp order by sal desc)
where rownum <= 3
| Is This Answer Correct ? | 9 Yes | 13 No |
Post New Answer View All Answers
Why use resource manager in Oracle?
What happens to indexes if you drop a table?
What are the differences between interval year to month and interval day to second?
Explain about the analyze command in oracle?
How to download oracle database 10g xe?
What are nested tables?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is oracle in java?
what is the difference between substr and instr function in oracle?
 How to use an oracle sequence generator in a mapping?
What are the different pseudo commands? Explain in general?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How can we find out the current date and time in oracle?
What is the difference between truncate & delete command?
How to get execution statistics reports on query statements?