select * from table1 a where n = (select count(distinct (sal)) from table1

how can we find nth max salary from A table

Question Posted / sivaraman

Answer Posted / sivaraman

select * from table1 a where n = (select count(distinct
(sal)) from table1 b where b.sal>a.sal)

n is value of n it should be numeric....

Is This Answer Correct ?

15 Yes

15 No

Please Help Members By Posting Answers For Below Questions

What is reorg?

1164

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1242

How can we read records for specific member in CL? AND rpg?

706

Define db2 and its databases?

1059

What is a collection in db2?

1037

What is multi row fetch in db2?

1053

How do I import a csv file into db2?

994

What is an instance database?

1057

What does sqlcabc has?

1058

How to find schema of a table in db2?

1018

What is the use of db2?

1058

What is the physical storage length of the data types date, time, and timestamp?

1093

B37 abend during spufi?

1458

Explain about open switch business continuity software?

1140

What is plan in cobol db2?

1142