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

What is the primary use of normalization?

1012

Can we group by two columns in sql?

1001

What are system versioned tables?

1034

How do you use a while loop in pl sql?

1016

What is pl sql in oracle?

1048

Can we create clustered index without primary key?

971

What is before trigger?

1007

Define union, minus, union all, intersect ?

1012

What do you know by pl/sql cursors?

1110

Can we use update in sql function?

1069

what are the differences between char and varchar? : Sql dba

1077

Explain locks? : Transact sql

1012

What are the different datatypes available in PL/SQL?

1091

How would you pass hints to the sql processor?

987

Why we use join in sql?

980