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

10 Answers
17786 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is blu acceleration in db2?

1078

What is view db2?

1085

Explain package in db2 and its advantages?

1220

What is the use of dclgen in db2?

1085

What is an instance in db2?

1040

What is alias in db2?

1068

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1187

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2396

How to check table size in db2 sap?

1044

What is copy pending status in db2?

1127

What is null value in db2?

1032

What is lock escalation in db2?

1039

What is syscat in db2?

1020

What is difference between isnull and coalesce?

1060

How can you classify the locks in db2?

1093