企业1有20条数据,企业2有30条数据。。。。。企业8有50条数据,取每个企业的前10名,做个表,如何写语句:select * from (SELECT ROW_NUMBER() OVER (ORDER BY avg(zongshu) DESC ) AS XUHAO,gongsi,zhibiao,avg(zongshu) as zongshu FROM biao where createdate>='2024-07-08' and createdate<='2024-07-09' group by gongsi,zhibiao ),每个企业取10条,假如10个企业,就取100条数据