how can we retrieve the 100 records of the file ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / anjireddy vintha
select * from tabblename where rownum<101
Is This Answer Correct ? | 3 Yes | 4 No |
What is a view? Why use it?
what is load and unload in db2
What is the difference between TYPE 1 index & TYPE 2 index
how to resolve -811
What is query for your birthday date should be in hours,minute and seconds format?
Are views updateable?
What is a page?
Name some fields from SQLCA
what is the difference between declaring the cursor in WS section and Procedure division?
What is a system catalog table in db2?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What is meant by a unit of recovery?