按表格中两个字段（姓名，项目）进行分组，组内按照sum（数量），sum(金额)进行汇总并排序，并输出每组的前10条记录
select zzys1xm as 姓名,hkxmmc as 项目名称,sum(hksl) as 总数量,sum(hkxj) as 总金额 from "v_hub_dwd_confirmation" where hkjg = '？' group by zzys1xm,hkxmmc,hksl order by sum(hkxj) 后续sql我该如何改写或是重新编写 |
1min目标场景问卷
立即参与
