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 / m sharib
delete from table1 where policy_no =(select policy_no from table1 limit 6,1);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the contention situations caused by locks?
What is the use of predicate?
Is db2 a mainframe?
What is dbrm library?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Before you give the explain statement, what are the prerogatives?
How connect db2 database to datastage?
What is dbrm? When it will be created?
What is declare cursor?
What is database alias db2?
Is ibm db2 open source?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the use of db2 optimizer?
What is sqlca?
What is collection in db2 bind?