请教一个简单的sql查询问题

[pbtech]

现在要select 出仓库中所有的货物单价(price)和数量(mount)，计算出各中货物的总额
price*mount,然后要汇总所有货物的价格sum(price*mount)，这条sql语句怎样写？

select price,mount,sum(price*mount) from uprvdmx
我这样写总是提示 、列 'uprvdmx.price''uprvdmx.cost 在选择列表中无效，因为该列未包含在聚合函数中，并且没有 GROUP BY 子句。“

[lbd8848]

select price,mount,sum(price*mount) from uprvdmx group by price,mount

[CrazyFor]

select price,mount,sum(price*mount),'1' as groupbystr into #temp from uprvdmx group by 货物


select price,mount,sum(price*mount) as mount from #temp

select sum(mount) from #temp group by groupbystr

[CrazyFor]

select price,mount,sum(price*mount) as totalAmount,'1' as groupbystr into #temp from uprvdmx group by 货物


select price,mount,sum(price*mount) as Pmount from #temp

select sum(totalAmount) from #temp group by groupbystr