数据库group by ....having命令
select sum(math) from student2 group by class按class分组,显示math求和
elect sum(math) as s from student2 group by class HAVING s>200;按class分组,显示math求和>200的
select sum(math) from student2 group by class按class分组,显示math求和
elect sum(math) as s from student2 group by class HAVING s>200;按class分组,显示math求和>200的