postgre 行号

delete from declare_declareinfo_1 where guid in(select guid from (
SELECT guid,
ROW_NUMBER() OVER(PARTITION BY guid, guid ORDER BY guid asc) AS Row
FROM declare_declareinfo_1
) dups
where
dups.Row > 1)