怎么在行下面求合计？

[杜晨东]

select b.FNumber as 代码, b.FName as 名称,a.FQuantity as 数量 ,a.FUnitPrice as 单价, FAmount as 金额
from t_VoucherEntry a
inner join t_Account b
on a.FAccountID=b.FAccountID where b.FNumber like '%1112%'
怎么在行下面求合计？

[二月十六]

把上边的语句在作为一个临时表sum一遍，然后union到一起

[shinger126]

后面加上WITH CUBE或者WITH ROLLUP，你看哪个适合你就用哪个

[「已注销」]

sum函数求呵就行了

[tom0311]

select b.FNumber as 代码, b.FName as 名称,a.FQuantity as 数量 ,a.FUnitPrice as 单价, FAmount as 金额
from t_VoucherEntry a
inner join t_Account b
on a.FAccountID=b.FAccountID where b.FNumber like '%1112%'

[程序员的键盘]

select b.FNumber as 代码, b.FName as 名称,a.FQuantity as 数量 ,a.FUnitPrice as 单价, FAmount as 金额
from t_VoucherEntry a
inner join t_Account b
on a.FAccountID=b.FAccountID where b.FNumber like '%1112%'

union all

select null as 代码, null as 名称,null as 数量 ,null as 单价, sum(FAmount) as 金额
from t_VoucherEntry a
inner join t_Account b
on a.FAccountID=b.FAccountID where b.FNumber like '%1112%'

[墙头上乘凉]

select b.FNumber as 代码, b.FName as 名称,a.FQuantity as 数量 ,a.FUnitPrice as 单价, FAmount as  金额 
from  t_VoucherEntry a
inner join t_Account  b
on a.FAccountID=b.FAccountID where  b.FNumber like '%1112%'
union 
select null as 代码, '合计' as 名称,SUM(a.FQuantity) as 数量 ,SUM(a.FUnitPrice) as 单价, SUM(FAmount) as  金额 
from  t_VoucherEntry a
inner join t_Account  b
on a.FAccountID=b.FAccountID where  b.FNumber like '%1112%'

[zjlamp]

with cube

[xbmu3]

with cube