**Employee** table consists of Employee\_id, Employee name, and salary

How to delete the highest-paid employee from the employee table?
I tried

```
delete from employee
where salary = (select max(salary) from employee);

```

but it gives an error;

> 
> Error Code: 1093. You can't specify target table 'employee' for update
>  in FROM clause 0.0022 sec
> 
> 
>