In my table having 100 Rec. How can I delete the 7th row??
(we don't know what is data inside the table)
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 is database manager in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Can we insert update delete in view?
What does db2 blu stand for?
What is the use of runstats in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is netezza database?
What is the role of data manager in the db2 database?
Why do we bind in db2?
what is the role of the cursor in db2?
What is ibm db2 database?
What is explain in db2?
What are the bind parameters ibm db2?
What does sqlcabc has?
List some fields from sqlca?