大家帮帮忙!提示:当没有用 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)