摘要:
--分组筛选SELECT COUNT(StudentName)as 人数 ,sGrade as 年级FROM S2WHERE StudentNo>5--WHERE Address like '%上海%'GROUP BY SGradeHAVING COUNT(StudentNo)>1| WHERE和H 阅读全文
摘要:
模板 --每个年级有多少人SELECT COUNT (StudentName), SGrade as 年级FROM S2GROUP BY SGrade --总分SELECT SUM(Sorce) as 总分FROM S2GROUP BY SGrade --每科平均分SELECT SGrade,AVG 阅读全文