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 action db2 takes when a program aborts in the middle of a transaction?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What do you mean by commit and rollback?
What are the two types of logging in the db2 database? Explain them.
What is schema in db2?
How to check sequence on a table in db2?
What is cursor in dbms?
What are packages in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What are catalog tables in db2?
What is the role of union all and union
What is db2 command?
What is db2 stogroup?
what is diffrence b/w file-aid tool and file-aid utility???
what is utility for parm lib