select * from (select e.*,rownum r from (select distinct sal from emp ord

find out the third highest salary?

Question Posted / akshita

Answer Posted / akshita

select * from (select e.*,rownum r from (select distinct
sal from emp order by sal desc) e) where r = 3

Is This Answer Correct ?

43 Yes

16 No

Please Help Members By Posting Answers For Below Questions

Why do we need integrity constraints in a database?

1076

List out the difference between commit, rollback, and savepoint?

1094

How to insert a record into a table?

1120

How do I limit the number of rows returned by an oracle query after ordering?

1223

Explain the use of rows option in exp command.

1147

How does oracle handle read consistency?

1151

How to assign data of the deleted row to variables?

1115

What happens in oracle commit?

1079

Explain what does a control file contain?

1164

What are the different types of record groups in oracle? Explain each of them

1069

What is the difference between substr and instr?

1091

How to do a full database export?

1153

How many categories of data types in oracle?

1073

What happens if the imported table already exists?

1077

How to list all user accounts in oracle?

1066