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 clone table?
Explain various types of locks in db2?
Give a brief description of db2 isolation levels?
How do you find the maximum value in a column in db2?
How to check table size in db2 sap?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is database alias db2?
What are concurrency issues?
How to view db2 table structure?
How do I add a column to an existing table in db2?
What do you mean by between and in? Is between inclusive of specified range values?
What is ibm db2 client?
What is a plan and package in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Why do we bind in db2?