delete TableXXX where TableXXX.RECID in ( select max(TableXXX.RecId) from TableXXX where TableXXX.DATAAREAID = 'yy' AND ... group by TableXXX.zzz having COUNT(RECID) > 1) and TableXXX.DATAAREAID = 'yy'