where apply_name in (select t.apply_name from (select t.apply_name,t.总额, row_number() over(order by 总额 desc) rn from (select apply_name,sum(total_amount) as 总额 from m_business_traffic group by apply_name) t ) t where rn <= 10)
group by apply_name,traffic_type
~~~~~~~~~~~~~~~
select a.*
from
(
select t1.*,(select count(*)+1 from 表 where 分组字段=t1.分组字段 and 排序字段<t1.排序字段) as group_id
from 表 t1
) a
where a.group_id<=3 # 假设取前3条
1min目标场景问卷
立即参与
分类名按照前十员工姓名,系列名是交通工具，值是费用总额，要体现堆积效果每种交通工具的占比
