select * from (select distinct sal from emp order by sal desc) where r

find out the third highest salary?

Question Posted / swaminathan

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

Please Help Members By Posting Answers For Below Questions

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2577

How to recover a dropped table in oracle?

984

Please explain oracle data types with examples?

992

material view and view disadvantages?

1020

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2075

What is flashback in Oracle?

967

Explain an extent?

1051

How to see the table columns used in an index?

961

What is java oracle used for?

973

What is background process in Oracle?

1052

What are the different types of trigger and explain its various uses and functions?

1010

What is a trace file and how is it created in oracle?

974

What is an index associated with a constraint?

975

How to sort output in descending order in oracle?

989

How to view the tablespaces in the current database?

929