how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE

Answer Posted / shiva

delete from table where rowcount=3;

Is This Answer Correct ?    1 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

755


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

750


What is query_cache_limit?

549


Is the primary key a clustered index?

615


What is a cursor in programming?

599






What are db2 objects?

641


How does cobol compile db2 program?

610


What is the difference between dbm cfg and db cfg file in db2 ?

1009


What is the use of reorg in db2?

612


What is ibm db2 database?

541


What is universal database?

623


Why do we need reorg in db2?

566


Is db2 a mainframe database?

569


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.

2327


What is the reason behind not using select * in embedded sql programs?

607