摘要:
-- 基于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 阅读全文
摘要:
with ete as ( SELECT * from table_name ) SELECT * from ete 阅读全文