Interested to Buy Any Domain ? << Click Here >> for more details...
how can we retrieve the 100 records of the file ?
- 2 Answers
- 8272 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Are view updateable?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is sqlcode -922 ?
How do I import a csv file into db2?
How does the processing of a correlated subquery differ from a non correlated subquery?
What is query_cache_limit?
How can you do the explain of a dynamic sql statement?
What is a view? Why use it?
When reorg is used?
i want to delete 20th million record how ?
What is the use of DELGEN in DB2? Can we Write the program with out using it?
What are db2 tables?
COBOL 
