语句去重 | 语句去重 | select *from ((select row_number() over(partition by 分布键 order by 主键,日期) as rn,* from table)t where t.rn=1 ) |
删除重复 | 删除重复 | delete from (select *from ((select row_number() over(partition by 分布键 order by 主键,日期) as rn,* from table)t where t.rn>1 ) ) |