大家帮帮忙！提示：当没有用 EXISTS 引入子查询时,在选择列表中只能指定一个表达式
delete from table1 where AA=(SELECT *
FROM TABLE1
WHERE (AA IN
(SELECT AA
FROM TABLE1
GROUP BY AA
HAVING COUNT(AA) > 1)))
提示：当没有用 EXISTS 引入子查询时,在选择列表中只能指定一个表达式

[解决办法]
delete from table1
where AA IN
(SELECT AA
FROM TABLE1
GROUP BY AA
HAVING COUNT(AA) > 1)