找个测试库试试 ctid
参考：https://www.cnblogs.com/lottu/p/5613098.html

jiekexu=# select * from t;
 id |         name         | age 
----+----------------------+-----
  1 | JiekeXu              |  18
  1 | JiekeXu              |  18
  2 | Jieke                |  20
  2 | Jieke                |  20
(4 rows)

jiekexu=# delete from t where ctid not in (select min(ctid) from t group by id);
DELETE 2
jiekexu=# select * from t;
 id |         name         | age 
----+----------------------+-----
  1 | JiekeXu              |  18
  2 | Jieke                |  20
(2 rows)

jiekexu=# insert into  t values(2,'Jieke',20);
INSERT 0 1
jiekexu=# select ctid,* from t;
 ctid  | id |         name         | age 
-------+----+----------------------+-----
 (0,1) |  1 | JiekeXu              |  18
 (0,3) |  2 | Jieke                |  20
 (0,5) |  2 | Jieke                |  20
(3 rows)

jiekexu=# select min(ctid) from t group by id;
  min  
-------
 (0,3)
 (0,1)
(2 rows)

jiekexu=# delete from t where ctid not in (select min(ctid) from t group by id);
DELETE 1
jiekexu=# select ctid,* from t;
 ctid  | id |         name         | age 
-------+----+----------------------+-----
 (0,1) |  1 | JiekeXu              |  18
 (0,3) |  2 | Jieke                |  20
(2 rows)
复制