如何解决此sql错误以删除重复数据[duplicate]

问：

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;

我正在尝试删除具有多个store_id的行，并出现以下错误：missing select keyword is the output

删除重复数据