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
How to find the maximum value in a column in the db2 database?
What kind of database is db2?
What is db2 catalog database?
What is dbrm? What it contains? When it will be created?
What is runstats and reorg in db2?
What happens in bind step in a db2 program?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Explain about dbrm.
What does sqlcabc has?
Explain db2.
How is deadlock resolved?
How to fetch the last row from the table in SQL (db2)?
What are the full forms of spufi and dclgen and why are they used?
Which isolation level provides maximum concurrency?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?