how to delete perticular row from table
for ex. how you will delete 3rd row from table
please answer
THANKS IN ADVANCE
Answer Posted / anjireddy vintha
delete from tablename where rownum=3
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How is a typical db2 batch pgm executed?
What are packages in db2?
What is lock escalation in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is cascading rollback?
How to view db2 table structure?
What is ibm db2 used for?
What are the different types of base tables?
What is deadlock in db2?
What is dclgen in db2?
How do I import data from excel to db2?
What is the purpose of rollback and commit?
What is buffer pool and list some of them?
What is meant by explain?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?