查询表中两个条件下的数目，按三列组成表

查询表中两个条件下的数目，按三列组成表。

SELECT BatchID,GroupProjectsID,count(*)
  FROM [dbo].[BasicProjectsInfo]
  Where BatchID=201408 and GroupProjectsID=2

报错：

消息 8120，级别 16，状态 1，第 4 行

选择列表中的列 'dbo.BasicProjectsInfo.BatchID' 无效，因为该列没有包含在聚合函数或 GROUP BY 子句中。

select BatchID, GroupProjectsID, count(*) from [dbo].[BasicProjectsInfo]
   group by BatchID, GroupProjectsID  having BatchID='201408' and GroupProjectsID='2';

select BatchID, GroupProjectsID, count(*) from [dbo].[BasicProjectsInfo]
   group by BatchID, GroupProjectsID 

添加 As 可以重命名列

select BatchID, GroupProjectsID, count(*) AS Cout from [dbo].[BasicProjectsInfo]
   group by BatchID, GroupProjectsID