select t1.id,t1.name
from
(
select
t.id
,t.name
,row_number()over(partition by t.id order by t.date) rn
from A t
) t1
where t1.rn<=10;
结果如下：
标签：10,t1,dorics,mysql,rn,id,select From： https://www.cnblogs.com/mangwusuozhi/p/17315297.html