本文共 635 字,大约阅读时间需要 2 分钟。
查询表中两个条件下的数目,按三列组成表。
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