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

Can dml statements be used in pl/sql?

1021

What is dense_rank in sql?

917

How do I remove duplicates in two columns?

977

Why left join is used in sql?

919

What is left join in postgresql?

998

How do I run a pl sql procedure in sql developer?

916

Can a procedure in a package be overloaded?

984

what are the properties and different types of sub-queries? : Sql dba

969

Which query operators in sql is used for pattern matching?

904

Can we call stored procedure in function?

905

What are triggers and its uses?

1003

Is vs as in pl sql?

935

What is the current version of sql?

974

What is difference between joins and union?

1046

What are transaction and its controls?

968