select q.sal from emp q where 3=(select distinct(count(b.sal))

Find out the 3rd highest salary?

Question Posted / srikanth

Answer Posted / srikanth

select q.sal
from emp q
where 3=(select distinct(count(b.sal))
from emp b
where q.sal<=b.sal)

Is This Answer Correct ?

17 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is function and procedure in pl sql?

1048

Can you call pl/sql package functions from within a fast formula?

1042

How to use transactions efficiently : transact sql

1060

What are views in sql?

993

How to install oracle sql developer?

1049

What is the advantage of nosql?

1061

explain access control lists. : Sql dba

1003

what are the authentication modes in sql server? How can it be changed? : Sql dba

1435

Could you please provide oca (oracle 10g) dumps for my certification ?

5170

What is cold data?

966

What packages(if any) has oracle provided for use by developers?

5811

what is not null constraint? : Sql dba

1037

Is sql procedural language?

969

What is user defined functions?

987

what is the difference between sql and t-sql? : Transact sql

1088