查看去重 select * from ( select name,row_number() OVER (PARTITION BY $filter$) rownum from table ) a where a.rownum >1