|
| 20200 在 2023/4/8 10:01:26
说到： |
|
| |
查询和刘晨选的课程一样并且数量也一样的同学姓名 |
|
|
| 发言人：2020014433 |
发言时间：2023/4/8 10:08:13 |
select sname from student,sc where student.sno=sc.sno and sc.sno in(select distinct sno from sc scx where not exists(select * from sc scy where scy.sno in (select student.sno from student where sname='刘晨')and not exists(select * from sc scz where scz.sno=scx.sno and scz.cno=scy.cno))) and sname <>'刘晨' group by sname having count(*)=(select count(*) from sc,student where student.sno=sc.sno and sname='刘晨')
|
| 发言人：2020014439 |
发言时间：2023/4/8 10:02:30 |
select distinct tname,tglass,tsdept,cname
from course,teacher
where teacher.tno=course.tno and tglass='副教授'and tsdept='计算机系'
|
|
