In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)
- 9 Answers
- 14067 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tim v
Are we talking the 7th row as sorted by key or 7th physical row? Since the rows aren't normally physically stored in order, I'd have to go with the latter.
Everyone seems to assume there is a PK on the table, but yet we don't know anything about the data... Again, this points to 7th physical row.
I'd go with the delete where RID(table) = 7 option since this assumes the 7th row inserted based on position and not value.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are iseries servers?
Explain the function of data manager.
Define data page.
What is a db2 tablespace?
What is the meaning concurrency in the db2 database?
What are the various data types available in db2?
what is diffrence b/w file-aid tool and file-aid utility???
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the use of value function?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Discuss about db2 bind?
How do I optimize a query in db2?
What is bind in db2?
What is buffer pool?
What is dclgen in db2?
