sql基础
一个表student,三个字段,classicid,age,name,如何查出平均年龄大于20的班级?
select classicid from student group by classicid having avg(age) > 20;
一个表student,三个字段,classicid,age,name,如何查出平均年龄大于20的班级?
select classicid from student group by classicid having avg(age) > 20;
暂无评论。
评论功能维护中,当前仅展示历史评论。