select a.* from (SELECT 表别名.* , Row_Number()
OVER (partition by 重复字段名称 ORDER BY 排序字段名称) rnum
FROM 表名 表别名) a where a.rnum =1
select a.* from (SELECT 表别名.* , Row_Number()
OVER (partition by 重复字段名称 ORDER BY 排序字段名称) rnum
FROM 表名 表别名) a where a.rnum =1