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

How to find the maximum value in a column in the db2 database?

615


What kind of database is db2?

576


What is db2 catalog database?

585


What is dbrm? What it contains? When it will be created?

595


What is runstats and reorg in db2?

800






What happens in bind step in a db2 program?

569


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

656


Explain about dbrm.

609


What does sqlcabc has?

633


Explain db2.

621


How is deadlock resolved?

652


How to fetch the last row from the table in SQL (db2)?

1043


What are the full forms of spufi and dclgen and why are they used?

660


Which isolation level provides maximum concurrency?

668


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

633