select * from emp where sal in(select min(sal) from (select sal from emp o

find the third highest salary?

Question Posted / pradeep

Answer Posted / pradeep

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

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is java sql connection?

967

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

927

What is audit logout in sql profiler?

979

How do I remove sql developer from windows 10?

1016

How can a function retun more than one value in oracle with proper example?

1029

What are field types?

942

Is pl sql a programming language?

929

Which sql statement is used to delete data from a database?

898

What is pessimistic concurrency control? : Transact sql

1025

what are all the different normalizations? : Sql dba

962

What is pl sql and why it is used for?

1073

How can I speed up sql query?

907

What is mutating trigger?

971

How many types of indexes are there in sql?

935

Does a join table need a primary key?

905