Interested to Buy Any Domain ? << Click Here >> for more details...
how can we retrieve the 100 records of the file ?
- 2 Answers
- 8520 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
What is phantom read in db2?
Define buffer pool.
How do I optimize a query in db2?
How to restart a DB2 program?
Which is faster delete or truncate?
What is bind plan?
Define data page.
What is db2 optimizer?
What is ibm db2 connect?
What is image copy in db2?
What is runstats utility in db2?
How to execute stored procedures?
On which levels locks can be applied?
What is the difference between cursor stability and repeatable read isolation levels?
Is ibm db2 open source?
