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

Which components manage deadlocks in db2?

1012

What is dbrm? What it contains? When it will be created?

991

what is utility for parm lib

2307

What are the 2 sqlcodes that are returned?

1128

What is ibm db2 connect?

927

What does a deadlock mean in DB2?

1091

How to create db2 table in mainframe?

1097

What is alias in db2?

980

What is sqlca?

997

can all users have the privilage to use the sql statement select * (dml)?

1102

How do you concatenate the firstname and lastname from emp table to give a complete name?

1010

What is database reorganization?

1050

How to rename a table in DB2 ?

1024

What is the difference between bind and rebind in db2?

1390

What is a Foreign Key?

1034