如何删除Postgresql中的重复行？

2 回答

• 0

  这是使用窗口函数的解决方案：

  DELETE FROM phone_number_list 
   WHERE id IN 
      (SELECT id FROM 
         ( SELECT id, ROW_NUMBER() OVER 
           (partition BY phone_number, org_id ORDER BY id ASC) AS rnum
           FROM phone_number_list
         ) AS t WHERE t.rnum > 1);
  

  回复于 2024-05-04T03:37:19+08:00
• 0

  试试这个：

  delete from your_table where id in 
     (select max(id) from your_table
       group by org_id, phone_number
       having count(1) > 1);
  

  Here's a working sample at DB-Fiddle . 它运作正常 .

  回复于 2024-05-04T03:37:19+08:00