How will you delete duplicate records from a table?
- 7 Answers
- 23586 Views
- Google, I also Faced
- E-Mail Answers
Answer Posted / king
DELETE FROM FILE WHERE FIELD = ALL(SELECT FIELD FROM FILE
GROUP BY FIELD HAVING COUNT(*) > 1)
OR
DELETE FROM FILE WHERE FIELD = ANY(SELECT FIELD FROM FILE
GROUP BY FIELD HAVING COUNT(*) > 1)
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
How do I start db2 in windows?
What is lock escalation in db2?
Are view updateable?
What does reorg do in db2?
What is reorg and runstats in db2?
What is table space in db2?
What is db2?
can we view the access paths created by dbrm ? how ? thx
What is load utility in db2?
How can you quickly find out the # of rows updated after an update statement?
What is the information associated with sysibm.syslinks table?
How will you return the number of records in table?
What is multi row fetch in db2?
Who uses db2?
What is rct?
