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
Is the primary key a clustered index?
What is access path in db2?
How to fetch the last row from the table in SQL (db2)?
List out the data types available.
How will you return the number of records in table?
What are packages in db2?
Explain the function of data manager.
Explain about open switch business continuity software?
What is the use of commit in db2?
What does runstats do in db2?
Mention some fields that are a part of sqlca.
Explain about dbrm.
Mention the various locks that are available in db2.
What types of tables are there in the db2 database?
Explain about cursor stability?