如何应用GROUP BY在这种情况下

Question

我有在选择列表

isnull((SELECT sum(bi.PROGRESS_BIL + bi.HARD_BIL + bi.SOFT_BIL + bi.FEES_BIL + bi.OAFEE_BIL + bi.RETAINER_BIL + bi.PREMDISC_BIL - bi.CREDIT_TOT) 
FROM bo_Live5.dbo.BLT_BILLM bi 
WHERE bi.MATTER_UNO = m.MATTER_UNO), 0) AS billings_to_date 

我想知道如何在GROUP将此BY

此列的其中一列的查询

感谢

Answer 1

你会使用子查询：

select billings_to_date, . . . 
from (select isnull((SELECT sum(bi.PROGRESS_BIL + bi.HARD_BIL + bi.SOFT_BIL + bi.FEES_BIL + bi.OAFEE_BIL + bi.RETAINER_BIL + bi.PREMDISC_BIL - bi.CREDIT_TOT) 
        FROM bo_Live5.dbo.BLT_BILLM bi 
        WHERE bi.MATTER_UNO = m.MATTER_UNO 
        ), 0 
        ) AS billings_to_date 
     from . . . 
    ) t 
group by billings_to_date;