阅读背景:

使用带有COUNT的CASE中的列而不将其放在group by中

来源:互联网 
SELECT 
    COUNT([P].[pkPortfolioId]) AS [OutcomeNotSubmitted],
    [CG].[GroupName]
FROM
    opp.Portfolio AS [P]
INNER JOIN 
   [vendor].[CustomerGroup] AS [CG] ON [P].[fkCustomerGroupId] = [CG].[pkCustomerGroupId]
WHERE 
    fkOutcomeId IS NULL
GROUP BY 
    [CG].[GroupName]
SELECT 
    COUNT([P].[pkPortfolioId]) AS [Outc



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: