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

Enlist the data types that can be used in pl/sql?

1071

What is vector point function?

1052

How do you go back in sql?

985

What is an exception in pl/sql?

1087

what is oracle database ? : Sql dba

1025

Why do we use %rowtype & %type in plsql?

1048

What is sql used for?

1124

What is rownum in sql?

1043

what are myisam tables? : Sql dba

1032

Is full outer join same as cross join?

969

What are the query optimization techniques?

934

define sql insert statement ? : Sql dba

1023

How do I create a sql script?

1099

how to drop an existing view in mysql? : Sql dba

1060

Why is the cursor important?

1043