select max(sal) from emp a where 5=(select count(distinct sal) from em

There is a 5000 EMP in company.how we find out the 5th
highest getting salary employee outof 5000 employes........

Question Posted / nagireddy

Answer Posted / nagireddy

select max(sal) from emp a where 5=(select count(distinct sal)
from emp b where a.sal<=b.sal);

Is This Answer Correct ?

13 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is db2 optimizer?

1231

What is explain in db2?

1014

What is universal database?

1066

What does reorg do in db2?

1026

How can you quickly find out the # of rows updated after an update statement?

1039

What is db2 connect?

1067

How do I import a csv file into db2?

989

What is node in db2?

1042

What is db2 look?

1020

What are the bind parameters ibm db2?

1048

What is declare cursor?

1118

Mention some fields that are a part of sqlca.

1020

What are union and union all?

981

What are db2 objects?

1045

What is bind plan?

1045