Interested to Buy Any Domain ? << Click Here >> for more details...
how can we retrieve the 100 records of the file ?
- 2 Answers
- 8316 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 |
What is check constraint. Explain with example.
How do I connect my db2 database to ibm?
How can you get the number of rows impacted by the last executed query?
What parameters are used to control the free space in DB2?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
what is Static and dynamic linking
Define db2.
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
List down the types of triggers in the db2 database?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
How to run db2 command in windows?
COBOL 
