Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ibm db2 connect?

1054


What does a deadlock mean in DB2?

1217


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2295


what is the responsibility of the construction superintendent

2209


What is the role of union all and union

1186


What is rct?

1287


What is difference between alias and synonym in db2?

1195


Why db2 is called db2?

1105


What is the maximum length of sqlca?

1610


What is bind package and plan in db2?

1105


what is diffrence b/w file-aid tool and file-aid utility???

4959


What is an instance in db2?

1084


What is a cursor in programming?

1112


How can you do the explain of a dynamic sql statement?

1107


What is the difference between plan and package in db2?

1170