【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“050.sql”一文,供大家参考学习!
select 课程号,课程名,学时,考试时间
from tb_course03 as T
where unique(select 学生编号 from tb_student03 where 课程号=T.课程号)
select
课程号,课程名,学时,考试时间 from tb_course03 as T
where (select count(*) from tb_student03 where 课程号=T.课程号)=1