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

How can you quickly find out the # of rows updated after an update statement?

634

Is ibm db2 open source?

589

Explain how can you do the explain of a dynamic sql statement?

656

Comment whether the cursor is closed during commit or not.

676

How do you stop a db2 database in linux?

570

Explain about rct in db2?

643

What is isolation level in db2?

580

What is a system catalog table in db2?

590

Is it possible using max on a char column?

613

What is package in cobol db2?

704

What are union and union all?

541

How to access db2 tables in mainframe?

615

What is the physical storage length of the data types date, time, and timestamp?

614

What is ibm db2 database?

541

What is the physical storage length of time data type?

678