select 供货商,sum(数量) 数量, sum(数量 * S)/sum(数量) as S,
sum(数量 * P)/sum(数量) as P,
sum(数量 * Fe)/sum(数量) as Fe,
sum(数量 * Ca)/sum(数量) as Ca
from tablename
group by 供货商
sum(数量 * P)/sum(数量) as P,
sum(数量 * Fe)/sum(数量) as Fe,
sum(数量 * Ca)/sum(数量) as Ca
from tablename
group by 供货商
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货