1、男学生出生日期的最大值和最小值:
SELECT select max(sBirthday),min(sBirthday) from student where sSex='男'
2、平均成绩
select avg(english) from score
select sum(sAge) as 年龄和 from student
5、count求个数和
select count(*) as 总人数 from student
聚合函数不能出现在Where字句中
原文链接:https://www.f2er.com/javaschema/286797.html