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

What is temporal table in db2?

1047

What is the physical storage length of timestamp data type?

1101

Is db2 a mainframe?

1051

What is the role of schema in the db2 database?

1279

What does reorg do in db2?

1037

How to find schema of a table in db2?

1018

B37 abend during spufi?

1462

How to test SQL -911 error while developing COB-DB2 program

7584

How does db2 sample database connect?

1034

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2951

Which is faster delete or truncate?

1133

What is copy pending status in db2?

1127

Can we delete records from view?

972

Mention the different locking levels that are available in db2.

1138

How do you eliminate duplicate values in db2?

1201