说明:字段2有重复 ,取字段1的一个值 select * from (select 字段 1,字段2,row_number() over (parition by 字段2 order by 字段 1) sn from table) a where a.sn =1