题看上面
错误示例
原因是,你不能一边查这个表(子查询),一边把这个表给删了
delete from titles_test
where id not in
(select min(id) from titles_test group by emp_no)
正确示例
子查询使用临时表
delete from titles_test
where id not in
(select * from (select min(id) from titles_test group by emp_no) as temp)