MySQL第五次作业

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

select * from teacher where no between "t5" and "t10";

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

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

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

select distinct teacher_no from wangrong_school_teaching;

 4，查询授课表中教室在J栋的所有字段数据，取2-3条

select * from wangrong_school_teaching where class_num like "j%" limit 3;