How will you delete duplicate records from a table?
Answer Posted / mehdee
Hi. This is a database design problem, because if you
alowe duplicate rows then you must have at least a column
being like squence number.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain about cursor stability?
Name the various locking levels available?
What is a system catalog table in db2?
can all users have the privilage to use the sql statement select * (dml)?
How to check last update on table in db2?
What is the maximum size of varchar data type in db2?
What is the reason behind not using select * in embedded sql programs?
What is the maximum size of a char data type in db2?
What is the syntax for creating a table in the db2 database?
What is declare cursor?
How to run db2 command in windows?
what is the role of the cursor in db2?
How to test SQL -911 error while developing COB-DB2 program
What is database reorganization?
Define check constraint.