Question

sql server两个表的合计值进行相减

有两个表A和B，A中的值进行汇总例如select sum(getmoney) from a，减去B表中的汇总select sum(paymoney) from b,有什么办法可以让这两个表中的值进行相减，得到一个他们两个的余数！在线急等！

Answer 1

PL/SQL块：这样的出来直接只有一个余数
DECLARE
@C1 INT,
@C2 INT,
@C3 INT
BEGIN
select @c1=sum(getmoney) from a
select @c2=sum(paymoney) from b
SET @C3=@C1-@C2
PRINT @C3
END
还可以：这样得出是个无名列
select isnull((select sum(getmoney) from a),0) - isnull((select sum(paymoney) from b),0)

Answer 2

select
isnull((select sum(getmoney) from a),0) - isnull((sum(paymoney) from b),0)

Answer 3

select (select sum(getmoney) from a) -(select sum(paymoney) from b)