sinat_42410314的博客

查询成绩在80~90之间的记录。 SELECT Student.Sno,Sname,Dept,Course.Cno,Score FROM Student,SC,Course WHERE Student.Sno=SC.Sno AND SC.Score BETWEEN 80 AND 90 AND SC.Cno=Course.Cno 查询至少有4个同学选修的课程名。 USE jia...

3-2 usejxsk insertintoSC values('s3','c2','70') insertintoSC values('s3','c4','85') insertintoSC values('s4','c2','85') insertintoSC values('s4','c3','83') insertintoSC values('s5','c...