赞
踩
单个字段去重 distinct
多字段查重(去重使用delete)
多字段:cxkh,jysj
select shard_id ,row_number() over (partition by cxkh,jysj) counts from table )t where t.counts >2