【简答题】查询没有学全所有课程的同学的信息
已帮助 人
回答
共1条回复-
Select s.sno, s.snameFrom s,scWhere s.sno=sc.snoGroup by s.snoHaving count(sc.cno)( select count(cno) from c)
Select s.sno, s.snameFrom s,scWhere s.sno=sc.snoGroup by s.snoHaving count(sc.cno)( select count(cno) from c)