select min(sal) from emp where sal in ( select sal from ( select sal fro

find the third highest salary?

Question Posted / noorulahaq

Answer Posted / noorulahaq

select min(sal) from emp where sal in (
select sal from
( select sal from emp order by sal desc )
where rownum <=3 )

Is This Answer Correct ?

26 Yes

17 No

Please Help Members By Posting Answers For Below Questions

What is sql*loader?

1275

What are all the different normalization?

1077

What is clustered index sql?

1022

What is error ora-01000: maximum open cursors exceeded

1202

Can there be more than one function with a similar name in a pl/sql block?

1035

How is data stored on a disk?

1078

How to connect a sql*plus session to an oracle server?

1172

How long it takes to learn pl sql?

1060

What is sql lookup?

966

How do you modify a column in sql?

1043

what are the features and advantages of object-oriented programming? : Sql dba

1070

What is the difference between join and natural join?

978

What is lexical units in pl sql?

1200

How to start the command-line sql*plus?

1099

How do you get column names only for a table (sql server)?

1206