??group by sno
??having count(distinct cno)>=2)
??3，即学过1号课程有学过2号课所有学生的姓名。
??select sname from s where sno in (select sno from sc where cno = 1 and sno in (select sno from sc where cno = 2)) ??
sqlserver2008上机五套试题及答案(5)
2019-08-31 23:19
sqlserver2008上机五套试题及答案(5).doc
将本文的Word文档下载到电脑
下载失败或者文档不完整，请联系客服人员解决！