随笔分类 -  SQL

摘要：--创建视图create view StuClassView as SELECT s.ID ,s.StuName ,s.StuAge ,s.StuAddress ,s.StuTel ,s.ClassId ,s.StuId,s.StuSex ,e.ClassName,e.ClassInfo,e.ClassFlag FROM Classes as e left join Students as s on s.ClassId=e.ClassIdselect sc.ClassName as '班级名称',count(sc.StuId) as '总人数' ,sum(cas 阅读全文