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

Highlight all the advantages that are attached to a package.

630

What is meant by union and union all?

591

Why do we need reorg in db2?

566

What is catalog database in db2?

646

How would the varchar column remarks defined?

641

Is db2 relational database?

574

Define check constraint.

646

Before you give the explain statement, what are the prerogatives?

581

What is the role of data manager in the db2 database?

649

Define predicate?

645

Which isolation level provides highest data integrity?

599

What is the maximum size of a char data type in db2?

588

what are bind concepts in db2 cobol?

653

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

723

What is the maximum length of sqlca?

871