作业帮 > 英语 > 作业

在关键字 'group' 附近有语法错误.

来源:学生作业帮 编辑:搜狗做题网作业帮 分类:英语作业 时间:2024/06/23 18:15:42
在关键字 'group' 附近有语法错误.
select sname
from s,sc
where s.sno = sc.sno
and sc.grade = null
having count(*) >= 2
group by sc.sno
在关键字 'group' 附近有语法错误.
select sname,sc.sno
from s,sc
where s.sno = sc.sno
and sc.grade = null
having count(*) >= 2
group by sc.sno
再问: 还是显示 那个 错误 。。
再答: select sname,sc.sno from s, sc where s.sno = sc.sno and sc.grade = null group by sc.sno having count(*) >= 2