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 the use of predicate?

1042

Explain about dbrm.

1047

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1077

How to find primary key of a table in db2?

1065

What is cursor in dbms?

1066

How to retrieve rows from a db2 table in embedded sql?

1390

Which components manage deadlocks in db2?

1071

What is sqlca?

1074

What type of database is db2?

971

List down the types of triggers in the db2 database?

1027

What is dbrm? What it contains? When it will be created?

1050

How do I change the column size in db2?

1157

B37 abend during spufi?

1455

What is the syntax for seeing the columns and data types of a table in the db2 database?

1167

Highlight all the advantages that are attached to a package.

1119