sql语言和数据分析方法.pptVIP

查询某个班级的所有课程和对应的授课老师 select tbl_Subject.SubjectName,tbl_teacher.TeacherName from tbl_ClassTeacher join tbl_Teacher on tbl_ClassTeacher.Teacher_OrderNum=tbl_Teacher.OrderNum join tbl_Subject on tbl_Teacher.Subject_OrderNum=tbl_Subject.OrderNum where Class_OrderNum=0010 显示出所有没有教课的老师的姓名 select * from tbl_Teacher where OrderNum not in (select Teacher_OrderNum from tbl_ClassTeacher) 2015-11 数据定义语言DDL 数据操纵语言DML 数据查询语言DQL 数据控制语言DCL SELECT * from tbl_Class SELECT [ClassName] FROM [tbl_Class] SELECT TOP 5 * FROM [tbl_Class] SELECT DISTINCT [Student_OrderNum] ,[Exam_OrderNum] FROM [tbl_Grade] 聚合函数