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|
How do you find the maximum value in a column in db2?
What are the 4 environments which can access DB2 ?
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.
When would you prefer to use VARCHAR?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
Mention the definition of cobol in varchar field.
where can we use index and subscript ? with example ?
What is db2 stogroup?
Comment whether the cursor is closed during commit or not.
My SQL is not performing well. Describe how will you fine tune it?
What is ibm db2 used for?
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 ..how to write query for this..