Delete duplicate rows in DB2/400 table

A simple way to delete duplicate rows using a query in a DB2/400 table is to use a query

DELETE FROM <TABLE NAME>  A
 WHERE RRN(A) >
   (SELECT MIN(RRN(B)) From <TABLE NAME> B
             Where A.COLUMN1 = B.COLUMN1
             and A.COLUMN2 = B.COLUMN2
             ... )

For Example use

delete From CUSTOMER A                        
    Where RRN(A) >                                     
          (Select Min(RRN(B)) From CUSTOMER B 
             Where A.ID= B.ID
             and A.NAME= B.NAME
             and A.CITY= B.CITY
             and A.STATE= B.STATE)