select * from agdet order by commission fetch first 5 rows only for read

i have table agdet i want first 5 maximum commission which
query will you write for this thanks in advance

Question Posted / thiru

Answer Posted / thiru

select * from agdet order by commission fetch first 5 rows
only for read only with ur

Is This Answer Correct ?

3 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What language is db2 written in?

1052

What is a db2 collection?

1053

Why db2 is called db2?

1051

List out the data types available.

1158

Explain in detail about buffer manager and its functionalities?

1073

How to rename a table in DB2 ?

1093

What are the various data types available in db2?

1100

What is dclgen (declaration generator)?

1066

How would you find out the total number of rows in a db2 table?

1057

Explain about cursor stability?

1058

What is cursor in dbms?

1074

How to restart a DB2 program?

1911

Can one database have multiple instances?

1058

What is a db2 tablespace?

1071

Explain package in db2 and its advantages?

1220