一个简单的select语句，重复的就统计次数

[zjroland]

有一个Project_Reports表，只有两个字段：

ReportID(int) ProjID(int)
1 56880
2 56880
3 56880
4 56886

我想得到的结果是：
ProjID Counts
56880 3
56886 1

就是ProjID不能重负，并统计重负次数，请问怎么写SELECT 语句？
select distinct ProjID,ReportID, Counts=count(ProjID) from Project_Reports group by ReportID,ProjID 实现不了。

[卖水果的net]

select distinct ProjID, Counts=count(ProjID) from Project_Reports group by ProjID

[二月十六]

--测试数据
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

[zjroland]

两位版主都是对的，结贴。