how can we retrieve the 100 records of the file ?
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 different three logs in DB2?
How to connect to db2 database from windows command line?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What parameters are used to control the free space in DB2?
What are the various isolation levels possible?
What is multi row fetch in db2?
Update command
What is image copy in db2?
What is a collection?
How do we specify index to include or not during bind process.
What are the three DB2 date and time data types and their associated functions?
List out the data types available.