SQL server查询代码实操例子
–查询选修了课程号为"01",“02”,“03"的学号、课程号和成绩记录select sno,s.cno,gradefrom score s,course cwhere s.cno=c.cno and (c.cno=‘08181192’ or c.cno=‘08181170’ or c.cno=‘08181060’)–(2)查询课程号"01”,“02”,“03"除外的,成绩大于分的学号、课程号和成绩记录select sno,s.cno,gradefrom score s,course cwh
原创
2021-06-04 22:25:47 ·
1706 阅读 ·
0 评论