select * from agdet a where 5 >= (select commission from agdet a , agd

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

Question Posted / girish

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

Please Help Members By Posting Answers For Below Questions

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3632

What is db2 look?

1075

What does sqlcabc has?

1098

What is difference between isnull and coalesce?

1106

What is dclgen (declaration generator)?

1113

When the like statement is used?

1280

What is the meaning concurrency in the db2 database?

1161

Explain what are the various isolation levels possible?

1095

Highlight all the advantages that are attached to a package.

1169

Explain packages.

1167

How to find the number of rows in db2 tables?

1127

What's The Percentage Free Space ?

1282

How do you stop a db2 database in linux?

1055

What is the use of dclgen in db2?

1135

What is null in db2?

1068