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)

posted @   徐徐图之  阅读(148)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示