how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
Answer Posted / ankit
hi
try with key word 'rownum' and 'rowcount'
ex: delete from table where rowcount=3;
correct me if i am wrong
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
What is the physical storage length of date data type?
Explain how can you do the explain of a dynamic sql statement?
What action db2 takes when a program aborts in the middle of a transaction?
How can the duplicate values be eliminated from db2 select?
Is ibm db2 free?
What is the use of reorg in db2?
What is database reorganization?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Differentiate between cs and rr isolation levels? Where do you specify them?
Explain about rct in db2?
What is a page in db2?
Why cursor is used in db2?
Explain the function of data manager.
Explain package in db2 and its advantages?
What is the cobol picture clause of the db2 data types date, time, timestamp?