摘要: -- 基于ig.start_pile,ig.end_pile 字段去重 with ete as ( SELECT * from (SELECT ROW_NUMBER() OVER(PARTITION by ig.start_pile,ig.end_pile ORDER BY ig.start_pil 阅读全文
posted @ 2022-10-28 11:25 懂得归零 阅读(1069) 评论(0) 推荐(0) 编辑
摘要: with ete as ( SELECT * from table_name ) SELECT * from ete 阅读全文
posted @ 2022-10-28 11:24 懂得归零 阅读(73) 评论(0) 推荐(0) 编辑