计算机应用研究所

20210 在 2024/11/1 14:35:40 说到：
	查询SC1表中所有重复选课的学生姓名及课程名称

这条发言的回复：

发言人：2021014625

发言时间：2024/11/1 14:36:17

select sname,cname from student,course,(select distinct sno,cno from sc1 where sno in(select sno from sc1 group by sno,cno having count(*)>=2) and cno in (select cno from sc1 group by sno,cno having count(*)>=2)),sc1 where student.sno=sc1.sno and sc1.cno=course.cno

TEL:-******** Email:yyh@zwu.edu.cn