如果重效率,就这样:
declare @total numeric(12,2)
select @total = sum(数量*单价) from table
select 数量/@total from table如果要简单,就这样:
select 数量/(select sum(数量*单价) from table)
from table
declare @total numeric(12,2)
select @total = sum(数量*单价) from table
select 数量/@total from table如果要简单,就这样:
select 数量/(select sum(数量*单价) from table)
from table
select sum(数量*单价)/sum(数量) from table唉...