学生表:
S(Sno, Sname)
课程表:
C(Cno, Cname)
成绩表:
SC(Sno, Cno, Grade)
sql语句:
select Sname from S
group by Sname
having count(Sname) in(select * from C)
新手上路,请多指教^_^
学生表:
S(Sno, Sname)
课程表:
C(Cno, Cname)
成绩表:
SC(Sno, Cno, Grade)
sql语句:
select Sname from S
group by Sname
having count(Sname) in(select * from C)
新手上路,请多指教^_^