select tt.dlr_code,tt.part_order_type,
sum(tt.PART_ORDER_AMOUNT) as TOTAL_AMOUNT,
round(RATIO_TO_REPORT(sum(tt.PART_ORDER_AMOUNT)) over() * 100, 2) || '%' as percent
from owndmssem.TT_SEM_PT_DLRORDER tt
group by tt.dlr_code,tt.part_order_type;这个是我增加的一个dlr_code是经销商的代码 上面的语句运行的结果是 DIR_CODE part_order_type TOTAL_AMOUNT percent
(经销商代码)
A1 A 122 32.4%
A1 D 156.2 56%
A1 T 441.3 65.3%
A2 A 5656 89%
A3 Z 54565 7%希望把上面4个相同的AAA04合并成一个记录
sum(tt.PART_ORDER_AMOUNT) as TOTAL_AMOUNT,
round(RATIO_TO_REPORT(sum(tt.PART_ORDER_AMOUNT)) over() * 100, 2) || '%' as percent
from owndmssem.TT_SEM_PT_DLRORDER tt
group by tt.dlr_code,tt.part_order_type;这个是我增加的一个dlr_code是经销商的代码 上面的语句运行的结果是 DIR_CODE part_order_type TOTAL_AMOUNT percent
(经销商代码)
A1 A 122 32.4%
A1 D 156.2 56%
A1 T 441.3 65.3%
A2 A 5656 89%
A3 Z 54565 7%希望把上面4个相同的AAA04合并成一个记录
这是什么?把想要的结果贴出来吧
A1 A D T
122 32.4% 156.2 56% 441.3 65.3%
你的part_order_type值是固定的还好,以后如果多一种B那不是要增加两个字段出来吗