Follow Our FB Page << >> 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 :
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 to write query for this..

1 Answers   HSBC,