Many times and Many places, this question is being asked :-) that How to delete the duplicate row from a table in different DBs. Here, we will see How to do this in DB2 DB.
DELETE FROM (SELECT ROWNUMBER() OVER (PARTITION BY COL1,
COL3) AS RNK FROM TABLE.NAME) AS A WHERE RNK > 1;
Like the Facebook Page & join Group
For WHATSAPP group , drop a msg to 91-88-00-906098