The query will be like this: Select distinct salary from table order by

How to get Top 10 Salaries from a Table

Question Posted / meena dogra

Answer Posted / meena dogra

The query will be like this:

Select distinct salary from table
order by salary desc
fetch first 10 rows only

Is This Answer Correct ?

31 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Explain package in db2 and its advantages?

1204

What is bufferpool in db2?

1046

Explain the contention situations caused by locks?

1066

How will you return the number of records in table?

932

On which levels locks can be applied?

1122

How to create db2 table in mainframe?

1154

How do I import a csv file into db2?

984

How to execute stored procedure in db2 command editor?

1047

How does cobol compile db2 program?

1048

What is alias in db2?

1052

What is the max length of sqlca?

1214

What is the use of reorg in db2?

1079

Give a brief description of db2 isolation levels?

1062

What is blu acceleration in db2?

1065

Can we update view in db2?

998