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

How to compare data between two tables in db2?

652


What is the use of reorg in db2?

593


What is a db2 schema?

754


What is the difference between plan and package in db2?

564


Define check constraint.

633






What type of database is db2?

519


Explain about mirror activator disk mirroring?

550


Why do we need reorg in db2?

553


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1644


what is the sqlcode -501

11256


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6806


How can we read records for specific member in CL? AND rpg?

226


What is drop table?

575


How do we specify index to include or not during bind process.

1667


What is plan in cobol db2?

580