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

Answer Posted / santhu

i think each row we can identify using ROWID . using ROWID
we can delete the row like fallowing

delete from <table_name> where rowid=3


correct me if i am wrong........

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where can you declare a cursor in a cobol-db2 program?

598


Explain about mirror activator disk mirroring?

554


How can you count the number of rows from a table tab?

627


What is commit in db2?

588


Is db2 a database?

566






Name the lockable units in DB2?

658


How many types of page locks can be held in db2?

585


List out the data types available.

694


What is the role of data manager in the db2 database?

634


How to find the number of rows in db2 tables?

605


What is rebind in db2?

568


What is query_cache_limit?

541


How is deadlock resolved?

644


What is check constraint in db2?

597


How to test SQL -911 error while developing COB-DB2 program

6698