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.
Answer Posted / nadeem
Use any one column name and its value of the 10th row to
fetch the 10th..for eg
select * from Table where deptno = 0010(any column name and
its value of 10 row)
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What is the physical storage length of timestamp data type?
What is null in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What types of tables are there in the db2 database?
What is db2 command?
How many databases can be created inside an instance in db2 ?
What is bufferpool in db2?
How to test SQL -911 error while developing COB-DB2 program
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the difference between spufi and qmf?
Is schema the same as database?
What is dbrm?
What are the two types of logging in the db2 database? Explain them.
How do you pull up a query which was previously saved in qmf?
What is the role of union all and union