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
最新推荐文章于 2022-07-02 17:15:36 发布
select p.id, name,ROW_NUMBER() over(PARTITION by name order by p.id) names from person p