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

what is db2 restart?

2135

What does runstats do in db2?

1083

How can you classify the locks in db2?

1078

Is db2 free?

1077

How can deadlocks be resolved?

925

What is explain plan in db2?

968

Can you tell me how can you find out the # of rows updated after an update statement?

1081

Define db2.

1097

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2906

What language is db2 written in?

1028

What is copy pending status in db2?

1104

How do I optimize a query in db2?

1081

What is schema in db2?

1008

What is the role of union all and union

1104

Is db2 a mainframe?

1026