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 is difference between rollback and commit?

1205

What is temporal table in db2?

1101

Explain about dbrm.

1109

What are packages in db2?

1076

What is plan in cobol db2?

1206

Explain correlated sub-queries.

1096

Mention data types used in db2 ?

1203

What is cloudant database?

1158

define clustering index.

1072

Explain about mirror activator disk mirroring?

1063

List some fields from sqlca?

1107

Can we delete records from view?

1022

Are views updateable?

1236

What is a collection in db2?

1095

What is bind package and plan in db2?

1110