delete from xxxx a
where a.ctid = any(
array (
select ctid from (
select row_number() over (partition by dnportid),
ctid
from xxxx) t
where row_number > 1
)
);
pgsql 删除任意重复行
于 2023-03-30 15:45:29 首次发布