数据库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的

posted @ 2025-11-17 17:56  黑田慎平  阅读(3)  评论(0)    收藏  举报