i have a table like this :
Name ADDRESS
Toto 123 ...
Toto 456
ToTo 678
I would like to delete 2 last row...please tell me how to
delete its
Answer Posted / siri
DELETE FROM TABLE WHERE ADDRESS IN('456','678')
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you find the maximum value in a column in db2?
What are the 2 sqlcodes that are returned?
What is copy pending and check pending in db2?
What does db2 blu stand for?
Which are the db2 tools to protect integrity of the database?
What are catalog tables in db2?
Can there be more than one cursor open for any program?
What is runstats utility in db2?
Mention some fields that are a part of sqlca.
How can you quickly find out the # of rows updated after an update statement?
Mention the definition of cobol in varchar field.
How to find the number of rows in db2 tables?
How do I copy a table in db2?
How to connect to db2 database from windows command line?
How to run db2 command in windows?