how can we retrieve the 100 records of the file ?

Question Posted / visu.kanchamreddy

2 Answers
8521 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

What is sqlca?

0 Answers

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers

What will the DB2 optimizer do?

2 Answers

I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers

What are the different types of base tables?

0 Answers

How to resolve -917 sql code in DB2?

3 Answers Cap Gemini,

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers

how to resolve -811 error. give clear explination

4 Answers IBM,

What is the purpose of the QUIESE Utility?