mysql语句：根据某一个字段重复，只取list中第一条数据

select s.*  
from ( 
    select b.*, row_number() over (partition by b.[重复字段] order by b.[排序字段]) as group_idx  
    from table_name b
) s
where s.group_idx = 1