select max(sal) from tablename.

how can we find nth max salary from A table

Question Posted / venkat

Answer Posted / venkat

Is This Answer Correct ?

7 Yes

51 No

Please Help Members By Posting Answers For Below Questions

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

2860

What does a deadlock mean in DB2?

1169

what is the responsibility of the construction superintendent

2151

What are union and union all?

985

Where do you specify them?

1289

What is db2 catalog database?

1050

What is database reorganization?

1135

What is a system catalog table in db2?

1191

Explain db2.

1041

What kind of database is db2?

1038

What is scrollable cursor in db2?

1059

How do I add a column to a table in db2?

1106

What is temporal table in db2?

1047

What is rct?

1242

What is dpf in db2?

1115