SELECT
s.*
FROM
( SELECT *, row_number() over ( PARTITION BY [重复的字段] ORDER BY [排序字段] ) AS group_idx FROM [表名] ) s
WHERE
s.group_idx = 1
SELECT
s.*
FROM
( SELECT *, row_number() over ( PARTITION BY [重复的字段] ORDER BY [排序字段] ) AS group_idx FROM [表名] ) s
WHERE
s.group_idx = 1