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 runstats and reorg in db2?

1366

What is dbrm? What it contains?

1217

Mention the different locking levels that are available in db2.

1190

What are the rules for db2 programming?

1156

Explain package in db2 and its advantages?

1277

What is rebind in db2?

1121

What is the use of commit in db2?

1144

How do you stop a db2 database in linux?

1062

How to resolve deadlock issue

20334

What is the difference between using bind () and rebind () methods of naming class?

1466

Where do you specify them?

1376

What is the maximum number of columns in a db2 table?

1350

What is an instance database?

1098

Why cursor is used in db2?

1090

How do I delete a column in db2?

1157