mysql,dorics數(shù)據(jù)庫(kù)查詢不同類型數(shù)據(jù)前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;