select distinct salary from table name hwre rownum <=10

How to get Top 10 Salaries from a Table

Question Posted / regu

Answer Posted / regu

Is This Answer Correct ?

6 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to find the number of rows in db2 tables?

992

What is concurrency?

1147

Which is faster delete or truncate?

1068

What are the various isolation levels possible?

1047

What does sqlcabc has?

993

Mention the different locking levels that are available in db2.

1064

How to retrieve rows from a db2 table in embedded sql?

1321

Define buffer pool.

996

Define db2.

1061

What is the difference between using bind () and rebind () methods of naming class?

1324

What is a db2 schema?

1172

Why db2 is called db2?

969

How can we read records for specific member in CL? AND rpg?

643

Which component is used to execute the sql statements?

1051

What is drop table?

958