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
17663 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

How to find schema of a table in db2?

1000

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9157

How do I change the column size in db2?

1131

Explain db2.

1016

Can one database have multiple instances?

1035

What are the 2 sqlcodes that are returned?

1177

What is bind plan?

1036

What is the difference between dbm cfg and db cfg file in db2 ?

1518

What is catalog database in db2?

1145

What is explain plan in db2?

968

What is the use of dclgen in db2?

1065

can we view the access paths created by dbrm ? how ? thx

7059

What is lock escalation in db2?

1006

How to execute stored procedure in db2 command editor?

1034

Where do you specify them?

1248