34,838
社区成员




--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([ReportID] int,[ProjID] int)
Insert #T
select 1,56880 union all
select 2,56880 union all
select 3,56880 union all
select 4,56886
Go
--测试数据结束
Select ProjID,COUNT(1) AS Counts from #T GROUP BY ProjID