I want to delete duplicate rows using this query only : **delete from employee where ( select * from (select row_number() over (partition by id) rn from employee) alias) > 1;**



The above query is not working and giving this error message:

**Error Code: 1242. Subquery returns more than 1 row**