请教MYSQL求和语句？

[zpingfang]

请教给位老师，我想求每个商品是数量乘以价格，然后最后把总金额相加得到总数，请问应该怎么写呢？

[zpingfang]

请教各位老师

[二月十六]

select 
case when pinming is not null then pinming else '合计' end as pinming,
sum(shuliang) as shuliang,
sum(jiage) as jiage,
sum(shuliang*jiage) as jine 
from assj 
group by pinming with rollup