sql 语句请教

2018-05-21 04:43:22 1k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

通讯软件002——快速使用modscan进行modbus调试快速使用modscan进行modbus调试阅读详情

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 一下, 这么写感觉跟我想要的不一样,该怎么写?

...全文