How will you delete duplicate records from a table?
- 7 Answers
- 23705 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
What is a Foreign Key?
Explain in brief how does db2 determine what lock-size to use?
Is the primary key a clustered index?
How does db2 sample database connect?
How to access db2 tables in mainframe?
What are packages in db2?
What is the connection string to connect to the DB2 Database ?
What is the usage of open cursor command?
How can you find out the # of rows updated after an update statement?
How can you quickly find out the # of rows updated after an update statement?
Highlight all the advantages that are attached to a package.
What is the syntax for creating a table in the db2 database?
Define data page.
Differentiate between cs and rr isolation levels? Where do you specify them?
What does db2 blu stand for?
