--28)查询选修了课程名为“数据库”的学生的学号和姓名。
select sname,sno
from course,student
where course.cno in(
select cno
from course
where cname='sql') and course.cname=student.sno
group by sname
having count(cname)='sql'
显示错误 出不来
--28)查询选修了课程名为“数据库”的学生的学号和姓名。
select sname,sno
from course,student
where course.cno in(
select cno
from course
where cname='sql') and course.cname=student.sno
group by sname
having count(cname)='sql'
显示错误 出不来