Interested to Buy Any Domain ? << Click Here >> for more details...
how can we retrieve the 100 records of the file ?
- 2 Answers
- 8366 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / lu
your qestion is not clear ??? first 100 rows or 100 rows
any where ??
this is FIRST 100 row :
SELECT * FROM TABLE
FETCH FIRST 100 ROWS ONLY
now if u want retrieve 100 rows in any table, you have to
create a counter ....
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Explain about mirror activator disk mirroring?
How will you return the number of records in table?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What are the various isolation levels possible?
What is db2 and what is the use of db2 optimizer?
What are the rules for db2 programming?
Explain about rct.
Name the lockable units in DB2?
Highlight all the advantages that are attached to a package.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is the difference between dbm cfg and db cfg file in db2 ?
What types of tables are there in the db2 database?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is dbrm library?
What are bind parameters in db2?
