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 do you mean by rollback?

937

Can you use max on a char column?

1034

What is buffer pool in the db2 database?

1051

What is coalesce in db2?

1062

How do I delete a table in database?

978

What is the default page size of buffer pools?

1073

Explain the function done by data manager?

1221

What are db2 objects?

1004

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1096

Mention the downsides of page level lock.

1116

What does sqlcabc has?

998

What is the difference between spufi and qmf?

1055

Mention data types used in db2 ?

1109

How to find the maximum value in a column in the db2 database?

1020

Explain the contention situations caused by locks?

1017