|
|
|
|
|
|
| SQL Server练习题2 |
|
| 作者：武汉SEO闵涛 文章来源：敏韬网 点击数2546 更新时间：2007/11/14 13:07:11 文章录入：mintao 责任编辑：mintao |
|
|
|
SC1.SNO,[1号课成绩]=SC1.SCGRADE,[2号课成绩]=SC2.SCGRADE
FROM SC SC1,C C1,SC SC2,C C2
WHERE SC1.CNO=C1.CNO AND C1.NAME=''''1''''
AND SC2.CNO=C2.CNO AND C2.NAME=''''2''''
AND SC1.SCGRADE>SC2.SCGRADE
)SC WHERE S.SNO=SC.SNO
上一页 [1] [2] |
|
|
|
|
|
|
|
|
|
