Question

看看着sql哪里错啦？ --（4）查找出至少选修了两门的学生的学号和姓名。

use XSGLselect Sno,Snamefrom Student x where Cno <> ANY (select Cno from Score y where y.Sno=x.Sno)





Answer 1

Student 表中没有cno字段

追问

问题修改，看看这样行不？
use XSGL
select Sno,Sname
from Student x
where Sdept ANY
(select Sdept
from Score y
where y.Sno=x.Sno)

追答

看不懂你的写法
我的建议是
select x.sno,x.sname from student x,score y where x.sno=y.sno
group by x.sno,x.sname haveing count(*)>1

追问

能用嵌套查询吗？

追答

select * from student x where sno in (select sno from score y
group by sno having count(*)>1)

Answer 2

分组统计后，加上条件：
-----------------
SELECT Sno
,SName

,COUNT(*) AS CourseNum

FROM Student
GROUP BY Sno, SName
HAVING COUNT(*) > 1