简答题
管理系统中计算机应用
2014-01-04
在SQL Server 2000中，通过学生表STUDENT、课程表COURSE和教师表TEACHER查询大于全班某一个女生所选课程编号的所有任课老师信息。请写出命令语句。
参考答案
暂无
答案解析
sELEcT XM AS教师，zc AS职称
FROM TEACHER
WHERE BH=ANY(SELECT JSH FROM COURSE)
WHERE KH>ANY(SELECT KH FROM STUDENT WHERE XB
=’女’)(4P165-166)
FROM TEACHER
WHERE BH=ANY(SELECT JSH FROM COURSE)
WHERE KH>ANY(SELECT KH FROM STUDENT WHERE XB
=’女’)(4P165-166)