将其放在子查询中:
delete from table where columnA in ( select columnA from ( select columnA from YourTable group by columnA having count(*) > 1 ) t )

将其放在子查询中:
delete from table where columnA in ( select columnA from ( select columnA from YourTable group by columnA having count(*) > 1 ) t )