select p.id, name,ROW_NUMBER() over(PARTITION by name order by p.id) names from person p

select p.id, name,ROW_NUMBER() over(PARTITION  by name order by p.id) names from person p