sql 分组查询 统计


select COUNT(PrjInfo_ConstructionUnit),PrjInfo_ConstructionUnit
,COUNT(PrjInfo_ConstructionUnit)OVER()[_sum]
from PRJ_PrjInfo
group by PrjInfo_ConstructionUnitSQL2005+

解决方案 »

  1.   


    select COUNT(PrjInfo_ConstructionUnit),PrjInfo_ConstructionUnit
      ,(select  COUNT(PrjInfo_ConstructionUnit) from PRJ_PrjInfo ) [_sum]
    from PRJ_PrjInfo
    group by PrjInfo_ConstructionUnit
      

  2.   

    select COUNT(PrjInfo_ConstructionUnit),PrjInfo_ConstructionUnit ,(select COUNT(PrjInfo_ConstructionUnit) from PRJ_PrjInfo ) as [_sum]
     from  PRJ_PrjInfo  group by PrjInfo_ConstructionUnit 
      

  3.   


    select COUNT(PrjInfo_ConstructionUnit),PrjInfo_ConstructionUnit ,(select sum(PrjInfo_ConstructionUnit) from PRJ_PrjInfo)
    as _sum from PRJ_PrjInfo group by PrjInfo_ConstructionUnit