postgresql - 从临时表中删除记录时出现 SQL 语法错误

Question

我是 SQL 新手。我试图删除具有相同姓名和姓氏的重复客户记录。下面是我的命令

delete duplicated_records from  (
  select row_number() over (partition by name, surname
                            order by name, surname) as rn
      ,          * 
  from customer
) duplicated_records where rn > 1;

这给我这个错误

ERROR:  syntax error at or near "duplicated_records"
LINE 1: delete duplicated_records from  (

但是当我测试运行只是为了查看记录时，我没有收到任何错误。

select duplicated_records from  (
  select row_number() over (partition by name, surname
                            order by name, surname) as rn
      ,          *
  from customer
) duplicated_records where rn > 1;

如果我在这里做错了什么，谁能告诉我。提前致谢。

标签： postgresql