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

how can we find nth max salary from A table

Question Posted / bhaskar reddy

Answer Posted / bhaskar reddy

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

Is This Answer Correct ?

6 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1079

Is schema the same as database?

1062

What is cascading rollback?

1220

What is the difference between plan and package in db2?

1124

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1111

How can the duplicate values be eliminated from db2 select?

1107

What is the syntax for creating a table in the db2 database?

1110

What does db2 plan contain?

1031

What is page size in db2?

983

What is host variable in db2 cobol?

1084

How to rename a table in DB2 ?

1093

What is a db2 schema?

1241

Which command is used to remove all rows from a table?

1119

What is the maximum size of a char data type in db2?

1013

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2860