相同 的id 只取一条记录
select * from (select t.* , row_number() over(partition by t.id order by t.id desc) as sequence
from mian t ) a where sequence =1
相同 的id 只取一条记录
select * from (select t.* , row_number() over(partition by t.id order by t.id desc) as sequence
from mian t ) a where sequence =1