how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
- 10 Answers
- 12738 Views
- IBM, I also Faced
- E-Mail Answers
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
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Mention the location where the output received from explain statement is stored.
What is cloudant database?
Outputs of explain are with matchcols = 0. What does this signify?
Can you use max on a char column?
what is the sqlcode -501
What is buffer pool and list some of them?
what is the role of the cursor in db2?
Why do we use cursor?
How to find the maximum value in a column in the db2 database?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are the different types of base tables?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is a Foreign Key?
What is database reorganization?
