mysql,dorics数据库查询不同类型数据前10条信息

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;

结果如下：