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


Please Help Members By Posting Answers For Below Questions

How does coalesce work?

584


What does db2 mean?

587


What is cobol db2?

568


What is the difference between oracle and db2?

587


What is meant by dclgen?

618






Why db2 is called db2?

593


What is the advantage in De-normalizing tables in DB2?

745


How can we retrieve the total number of records in RPG & CLLE?

194


What is the use of value function?

628


What is meant by union and union all?

585


Explain about dbrm.

607


What is sqlca?

622


What are catalog tables in db2?

606


What is ibm db2 client?

523


What is page size in db2?

563