How to find 1st, 2nd, 3rd highest using select select
statement not using rownum
Answer Posted / ajit
select distinct *
from (select e.*,dense_rank()over(order by sal desc) rn from emp e)
where rn in (1,2,3);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain mutating triggers.
What is difference between truncate and delete?
How to set a transaction to be read only in oracle?
What is blob data type in oracle?
what is the difference between functional dependecy and multilevel dependency?
What are the differences between date and timestamp in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
How to run create database statement again?
How to change program global area (pga) in oracle?
What is tns name?
What happens to the current transaction if a ddl statement is executed?
What do you understand by a database object? Can you list a few of them?
How to create lov dynamically at runtime & attach to text field?
How to convert characters to times in oracle?
Explain integrity constraint?