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
- 3 Answers
- 6603 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Explain in brief how does db2 determine what lock-size to use?
What do you mean by cursor?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is multi row fetch in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is copy pending status in db2?
What action db2 takes when a program aborts in the middle of a transaction?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Is db2 a mainframe?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How to find primary key of a table in db2?
can we view the access paths created by dbrm ? how ? thx
How to resolve deadlock issue
How to get the ddl of a table in db2?
What are concurrency issues?
