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


Please Help Members By Posting Answers For Below Questions

What is a db2 collection?

803


What is db2 stogroup?

893


How is deadlock resolved?

840


Name the lockable units in DB2?

902


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

803


Are views updateable?

838


What is cobol db2?

741


What happens in bind step in a db2 program?

733


What is check constraint in db2?

817


Which are the db2 tools to protect integrity of the database?

907


How to find schema of a table in db2?

759


Mention the downsides of page level lock.

924


When reorg is used?

866


How does coalesce work?

760


How to get the ddl of a table in db2?

865