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

Why do we use function in pl sql?

1044

what is heap table? : Sql dba

1090

What are % type and % rowtype?

1020

What are local and global Indexes and where they are useful.

1431

Which constraints we can use while creating database in sql?

1056

how to extract a unit value from a date and time? : Sql dba

978

What does sign mean sql?

1071

Can we use having without group by in sql?

963

What is delete command in sql?

1087

What is difference between stored function and application function?

1172

What is %s in sql?

996

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1426

What are the popular database management systems in the it industry?

978

What is compiled query?

1014

What is scalar function?

1032