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

What is coalesce in db2?

1136

Explain about rct.

1090

What is the use of predicate?

1043

What is multi row fetch in db2?

1052

How many types of page locks can be held in db2?

1044

What is db2 bind process?

1241

What type of database is db2?

971

When the like statement is used?

1223

How do you select a row using indexes in db2?

1137

What is db2 plan table?

1052

What types of tables are there in the db2 database?

1061

What is difference between alias and synonym in db2?

1144

How to check sequence on a table in db2?

1064

Define declaration generator (dclgen).

1120

What is the use of with ur in db2?

1058