SELECT schoolId,个数=count(1) FROM ViewSchoolClass GROUP BY schoolId
SELECT schoolId ,count(*) FROM ViewSchoolClass GROUP BY schoolId
SELECT schoolId,count(1)as 学校个数 FROM ViewSchoolClass GROUP BY schoolId
SELECT schoolId,count(1) as 学校个数 FROM ViewSchoolClass GROUP BY schoolId
SELECT schoolId FROM ViewSchoolClass GROUP BY schoolId首先你的这个写法,其实等价于: SELECT DISTINCT schoolId FROM ViewSchoolClass 而你要想得到的结果的写法: SELECT schoolId ,COUNT(1) AS schoolCount FROM ViewSchoolClass GROUP BY schoolId
SELECT schoolId ,count(*)
FROM ViewSchoolClass
GROUP BY schoolId
SELECT schoolId,count(1)as 学校个数 FROM ViewSchoolClass GROUP BY schoolId
FROM ViewSchoolClass
GROUP BY schoolId首先你的这个写法,其实等价于:
SELECT DISTINCT schoolId
FROM ViewSchoolClass 而你要想得到的结果的写法:
SELECT schoolId
,COUNT(1) AS schoolCount
FROM ViewSchoolClass
GROUP BY schoolId