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
mysql语句:根据某一个字段重复,只取list中第一条数据
于 2022-09-07 10:19:11 首次发布
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