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
How does coalesce work?
What does db2 mean?
What is cobol db2?
What is the difference between oracle and db2?
What is meant by dclgen?
Why db2 is called db2?
What is the advantage in De-normalizing tables in DB2?
How can we retrieve the total number of records in RPG & CLLE?
What is the use of value function?
What is meant by union and union all?
Explain about dbrm.
What is sqlca?
What are catalog tables in db2?
What is ibm db2 client?
What is page size in db2?