摘要:
DELETE FROM dups a USING ( SELECT MIN(ctid) as ctid, key FROM dups GROUP BY key HAVING COUNT(*) > 1 ) b WHERE a.key = b.key AND a.ctid <> b.ctid 阅读全文
posted @ 2020-07-29 14:11 且行且思 阅读(193) 评论(0) 推荐(0) 编辑
|
|||
摘要:
DELETE FROM dups a USING ( SELECT MIN(ctid) as ctid, key FROM dups GROUP BY key HAVING COUNT(*) > 1 ) b WHERE a.key = b.key AND a.ctid <> b.ctid 阅读全文
posted @ 2020-07-29 14:11 且行且思 阅读(193) 评论(0) 推荐(0) 编辑
摘要:
postgresql中类似IFNULL用法 COALESCE('字段','字段') 阅读全文
posted @ 2020-07-29 07:57 且行且思 阅读(3929) 评论(0) 推荐(0) 编辑 |
|||