-->2005可以与窗口函数over一起用:select count(1)over(partition by object_id) as 列数, * from sys.columns
你要查看的列 要不在聚合函数里,要不在group by 里例子 table student 列名 id name 课程 成绩 select sum(成绩) from student 正确 select name, 课程 ,sum(成绩) from student group by 课程 错误 错误信息 :name 应包含分组group by 中 select name, 课程 ,sum(成绩) from student group by name,课程 正确
列名 id name 课程 成绩 select sum(成绩) from student 正确 select name, 课程 ,sum(成绩) from student group by 课程 错误
错误信息 :name 应包含分组group by 中
select name, 课程 ,sum(成绩) from student group by name,课程 正确