select * from (
SELECT *,row_number() over (partition by name) num FROM `users` ORDER BY LENGTH(shenfenzheng) desc
) a where a.num =1
//再user表中对name去重,留下身份证号最长
select * from (
SELECT *,row_number() over (partition by name) num FROM `users` ORDER BY LENGTH(shenfenzheng) desc
) a where a.num =1
//再user表中对name去重,留下身份证号最长