How will you delete duplicate records from a table?
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 database manager in db2?
What is data manager?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is dbrm in db2 database?
How to check sequence on a table in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is the role of data manager in the db2 database?
What is the purpose of using commit?
What is the meaning concurrency in the db2 database?
What is db2 instance?
How do you eliminate duplicate values in db2?
What is the information associated with sysibm.syslinks table?
How to execute stored procedures?
What is cursor with hold option in db2?
How many types of page locks can be held in db2?