mysql - 您不能在 FROM 子句中指定目标表“员工”进行更新

Question

delete from Employee where Salary=(select max(Salary) from Employee)

为什么显示错误。有人可以帮助我如何用逻辑解决它。

标签： mysql

Answer 1

DELETE t1.*
FROM Employee t1
JOIN (SELECT MAX(Salary) Salary FROM Employee) t2
where t1.Salary = t2.Salary