select p.id, name,ROW_NUMBER() over(PARTITION by name order by p.id) names from person p时间:2024-06-26 11:07:20select p.id, name,ROW_NUMBER() over(PARTITION by name order by p.id) names from person p