在关键字 'group' 附近有语法错误.select sname from s,scwhere s.sno = sc.snoand sc.grade = nullhaving count(*) >= 2group by sc.sno
来源:学生作业帮助网 编辑:作业帮 时间:2024/11/26 00:54:15
x){:g/{vzzQ~i˙-/O|66O}9eSsRKsSҊsu3RRlAļ+(1%(WX_W`g`M!&Hգ8
,wy` ,ncs(Xݵv6/-A[$ف h
在关键字 'group' 附近有语法错误.select sname from s,scwhere s.sno = sc.snoand sc.grade = nullhaving count(*) >= 2group by sc.sno
在关键字 '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 from s,scwhere s.sno = sc.snoand sc.grade = nullhaving count(*) >= 2group by sc.sno
select sname,sc.sno
from s,sc
where s.sno = sc.sno
and sc.grade = null
having count(*) >= 2
group by sc.sno