关于#GROUP BY#的问题，如何解决？
查询没有学全所有课程的学号姓名
代码如下
--表的联结
select s2.学号,s1.姓名
from chengji as s2 LEFT JOIN student as s1
on s1.学号=s2.学号
GROUP BY s2.学号
having COUNT(DISTINCT 课程号)<(select count(DISTINCT 课程号) from subject);
表如下
group by 学号，姓名 这样就可以了
查询没有学全所有课程的学号姓名
代码如下
--表的联结
select s2.学号,s1.姓名
from chengji as s2 LEFT JOIN student as s1
on s1.学号=s2.学号
GROUP BY s2.学号
having COUNT(DISTINCT 课程号)<(select count(DISTINCT 课程号) from subject);
表如下
group by 学号，姓名 这样就可以了