摘要： select p.id, name,ROW_NUMBER() over(PARTITION by name order by p.id) names from person p 阅读全文