--分组筛选
SELECT COUNT(StudentName)as 人数 ,sGrade as 年级
FROM S2
WHERE StudentNo>5
--WHERE Address like '%上海%'
GROUP BY SGrade
HAVING COUNT(StudentNo)>1|
2022-11-17 14:18:27
--分组筛选
SELECT COUNT(StudentName)as 人数 ,sGrade as 年级
FROM S2
WHERE StudentNo>5
--WHERE Address like '%上海%'
GROUP BY SGrade
HAVING COUNT(StudentNo)>1|