sql 语句请教
SELECT *,
((Convert(decimal(18,2),(Select isnull(SUM(Acount),0.00) From D Where Status<>'B'
AND cprID=C.cpr_Id and InAcountTime Between '2018-01-01' AND '2018-12-31'))) -(Convert(decimal(18,2)
,(Select isnull(SUM(InvoiceAcount),0.00) From D Where Status<>'B'
AND cprID=C.cpr_Id and InAcountTime Between '2018-01-01' AND '2018-12-31')))) as 差额,
-----差额的''和'' 语句 怎么写????----
from C
差额是个数值
现在我想在求一下这个差额的 和
该怎么写?
我尝试写了一下
SELECT *, sum(chae) as '差额总和' from (SELECT *,
((Convert(decimal(18,2),(Select isnull(SUM(Acount),0.00) From D Where Status<>'B'
AND cprID=C.cpr_Id and InAcountTime Between '2018-01-01' AND '2018-12-31'))) -(Convert(decimal(18,2)
,(Select isnull(SUM(InvoiceAcount),0.00) From D Where Status<>'B'
AND cprID=C.cpr_Id and InAcountTime Between '2018-01-01' AND '2018-12-31')))) as chae
from C ) T
报错,因为需要把所有的列都group BY 一下, 这么写感觉跟我想要的不一样,该怎么写?