i have table agdet i want first 5 maximum commission which query will you writ

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

Question Posted / ankithmf

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / girish

select * from agdet a where 5 >= (select commission from
agdet a , agdet b where b.commission > = a. commission)with
ur;

Is This Answer Correct ?

0 Yes

3 No

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

Answer / 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