mysql 学生 课程关系,设有一个学生-课程数据库,包括学生关系Student、课程关系C和选修关系SC.Student（sno,sname,ss...

共回答了15个问题采纳率：73.3%

1>select sno,sname from Student where sdept='IS'

2>select SNO,GRADE from SC where SNO=1

3>select SC.GRADE ,C.CName from SC , C where SC.SNO=990101 and SC.CNO=C.CNO

4>select Student.sname SC.SNO SC.CNO from Student inner join SC on Stuent.SNO=SC.SNO where SC.GRADE >95

5>select Student.sname ,SC.GRADE from Student inner join SC on Stuent.SNO=SC.SNO where SC.CNO=(select CNO from C where CNAME='ACCESS') order by SC.GREDE dec

6> select sno ,sname ,sdept from Student where sname like '王%'

有错的地方请指点!

1年前

3