Mysql数据库第五次作业——查询数据

查询教师表中教师号在T5到T10之间的所有字段数据：

select * from teacher where No between "T10" and "T5" ;

select * from teacher where No between "T10" and "T5" ;

查询授课表中 周数为14 的 课程号、教师号、周数、教室号 字段数据：

select teacher_no, course_no, week, class_num from school_teaching where week = 14;

select teacher_no, course_no, week, class_num from school_teaching where week = 14;

查询授课表中去重后的所有教师号：

 select distinct teacher_no from school_teaching;

 select distinct teacher_no from school_teaching;