Interested to Buy Any Domain ? << Click Here >> for more details...
how can we retrieve the 100 records of the file ?
- 2 Answers
- 8265 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 cursor with hold option in db2?
What does db2 mean?
How does db2 sample database connect?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is difference between isnull and coalesce?
What is collection in db2 bind?
What is the information associated with sysibm.syslinks table?
Is ibm db2 open source?
define clustering index.
What are the 2 sqlcodes that are returned?
What does reorg do in db2?
What is iseries database?
What is isolation level in db2?
Explain the contention situations caused by locks?
Can we delete records from view?
