Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how can we retrieve the 100 records of the file ?

Answers were Sorted based on User's Feedback



how can we retrieve the 100 records of the file ?..

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

how can we retrieve the 100 records of the file ?..

Answer / anjireddy vintha

select * from tabblename where rownum<101

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More DB2 Interview Questions

How do you find the maximum value in a column in db2?

0 Answers  


What are the 4 environments which can access DB2 ?

2 Answers  


I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  


When would you prefer to use VARCHAR?

3 Answers  


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,






Mention the definition of cobol in varchar field.

0 Answers  


where can we use index and subscript ? with example ?

3 Answers   CTS,


What is db2 stogroup?

0 Answers  


Comment whether the cursor is closed during commit or not.

0 Answers  


My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,


What is ibm db2 used for?

0 Answers  


Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,






Categories