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
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