How can i solve this sql error to delete duplicate data

Question

with CTE as 
(select s.*,row_number() over(partition by store_id order by store_id ) as rank from stores s)
DELETE FROM cte where cte.rank>1;

i am trying to delete row with multiple store_id by the error : missing select keyword is the output

delete duplicate data