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

what is different three logs in DB2?

1 Answers   Syntel,


How to connect to db2 database from windows command line?

0 Answers  


Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  


What parameters are used to control the free space in DB2?

0 Answers  


What are the various isolation levels possible?

0 Answers  






What is multi row fetch in db2?

0 Answers  


Update command

1 Answers  


What is image copy in db2?

0 Answers  


What is a collection?

3 Answers  


How do we specify index to include or not during bind process.

0 Answers   Satyam,


What are the three DB2 date and time data types and their associated functions?

1 Answers  


List out the data types available.

0 Answers  


Categories