exec sql select commission from agdet order by commission desc fetch firs

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

Question Posted / yuvaevergreen

Answer Posted / yuvaevergreen

exec sql
select commission from agdet order by commission desc
fetch first 5 rows only
end-exec;

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain correlated sub-queries.

593

How do I copy a table in db2?

581

What is coalesce in db2?

691

define clustering index.

627

i want to maintain uniqueness on pdf without make lf??????????

1644

How do I add a column to an existing table in db2?

604

List out the data types available.

712

How to check table size in db2 sap?

592

How to get the ddl of a table in db2?

687

Describe major components of db2?

649

What is cobol db2?

574

What is bind and rebind in db2?

658

List out the buffer pools in db2

644

What is meant by explain?

668

How to access db2 tables in mainframe?

623