how can we retrieve the 100 records of the file ?
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
How do I delete a table in database?
What language is db2 written in?
Can we insert update delete in view?
What is a db2 package?
What is the difference between cursor stability and repeatable read isolation levels?
Outputs of explain are with matchcols = 0. What does this signify?
What is a system catalog table in db2?
What is phantom read in db2?
How can you count the number of rows from a table tab?
How do I add a column to an existing table in db2?
How do I copy a table in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What is a db2 tablespace?
What is the result of open cursor statement?
Explain the function done by data manager?