You can't specify target table 'Employee' for update in FROM clause

Question

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

why is error is showing. can someone help me how to solve it with logic.

Please always search for your error using your favourite search engine before asking. — dirkgroten, Feb 17 '20 at 19:20

score 1 · Answer 1 · answered Feb 17 '20 at 18:26

1

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

answered Feb 17 '20 at 18:26

Akina

1 Answers1