select max(sal) from emp a where 3=(select count(sal) from emp b where b.

Find out the 3rd highest salary?

Question Posted / ratnakar

Answer Posted / ratnakar

select max(sal) from emp a where 3=(select count(sal) from
emp b where b.sal >=a.sal;

Is This Answer Correct ?

10 Yes

10 No

Please Help Members By Posting Answers For Below Questions

Are sql connections encrypted?

961

What is #table in sql?

997

What is aggregate function in sql?

988

Is sql developer case sensitive?

945

What are predefined functions in sql?

980

How you improve the performance of sql*loader? : aql loader

957

What is data control language?

949

What does the file extension accdb stand for?

919

Why is pl sql used?

939

what is sql? : Sql dba

973

What is a rank in sql?

901

Enlist the characteristics of pl/sql?

1744

What does select * from mean in sql?

3074

What is difference between procedure and trigger?

919

what are date and time data types? : Sql dba

933