delete from GOODS_USER_SOURCE a
where (a.PRODUCT_NAME_CN,a.TARIFF) in (select PRODUCT_NAME_CN,TARIFF from GOODS_USER_SOURCE group by PRODUCT_NAME_CN,TARIFF having count(*) > 1)
and rowid not in (select min(rowid) from GOODS_USER_SOURCE group by PRODUCT_NAME_CN,TARIFF having count(*)>1)