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

how can we find nth max salary from A table

Question Posted / asp

Answer Posted / asp

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

Is This Answer Correct ?

15 Yes

5 No

Please Help Members By Posting Answers For Below Questions

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

1020

Mention the downsides of page level lock.

1112

What do you mean by storage group (stogroup)?

984

What is page size in db2?

906

What is the physical storage length of time data type?

1066

How to restart a DB2 program?

1829

What do you mean by commit and rollback?

976

What is the difference between oracle and db2?

1033

What does db2 stand for?

961

List out the three types of page locks that can be held.

1093

What is an instance database?

1007

define clustering index.

980

Which command is used to connect to a database in DB2 ? Give the Syntax.

1032

What is the role of data manager in the db2 database?

1053

Can there be more than one cursor open for any program?

1125