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

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

select *from zhongzheng_teacher where NO between “T10” and “T5”;

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

select * from qiufaqing_school_teaching where week=15;

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

select distinct teacher_no from qiufaqing_school_teaching;

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

 select * from qiufaqing_school_teaching  where class_num like "j%" limit 2;