how can we retrieve the 100 records of the file ?
Answer Posted / anjireddy vintha
select * from tabblename where rownum<101
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is a storage group (stogroup)?
What is runstats db2?
List down the data types in the db2 database.
What is cascading rollback?
Explain the function of data manager.
If I have a view which is a join of two or more tables, can this view be updateable?
What is a trigger in the db2 database?
How do I add a column to a table in db2?
Explain how can you do the explain of a dynamic sql statement?
is it compulsory commitment control in journal?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
List out the buffer pools in db2
How does db2 sample database connect?
Can there be more than one cursor open for any program?