select b.* from student_score a,student b
where a.stuno=b.stuno
and a.stuscore=(select stuscore from student_score where stuscore between 10 and 60
where subjectid in(select subjectid from subject where subjectname='JavaWeb'))
and a.subjectid in(select subjectid from subject where subjectname='JavaWeb');
怎么修改?
where a.stuno=b.stuno
and a.stuscore=(select stuscore from student_score where stuscore between 10 and 60
where subjectid in(select subjectid from subject where subjectname='JavaWeb'))
and a.subjectid in(select subjectid from subject where subjectname='JavaWeb');
怎么修改?
解决方案 »
- win7下安装oracle10G的问题
- oracle job问题
- 被360害惨了!360的木马工具把oracle.exe的自动启动给关闭了。怎么设置开机自动启动啊?
- 使用C#访问Oracle,使用连接池,代码如何写,数据库端要不要做配置
- 怎么能查到一段时间内对某一个表都做了哪些操作?在线等
- oracle pl/sql:create functions pls-00013??
- 请教大家一个SQL语句,谢谢!!!
- 请教:change archivelog all validate的作用以及含义
- 请问存储过程中有没有关于静态变量的说法?
- 怎么在ORALCLE表中创建自增长ID字段啊?谢谢
- 一个数据库可以有二个例程么?
- 对于一个经常添加和删除的表,,应该怎么设计和维护呢
FROM STUDENT_SCORE A,
STUDENT B,
(SELECT * FROM STUDENT_SCORE WHERE STUSCORE BETWEEN 10 AND 60) C,
(SELECT SUBJECTID FROM SUBJECT WHERE SUBJECTNAME = 'JAVAWEB') D
WHERE A.STUNO = B.STUNO
AND A.STUSCORE = C.STUSCORE
AND C.SUBJECTID = D.SUBJECTID
AND A.SUBJECTID = D.SUBJECTID
FROM STUDENT_SCORE A,
STUDENT B,
(SELECT * FROM STUDENT_SCORE WHERE STUSCORE BETWEEN 10 AND 60) C,
(SELECT SUBJECTID FROM SUBJECT WHERE SUBJECTNAME = 'JavaWeb') D
WHERE A.STUNO = B.STUNO
AND A.STUSCORE = C.STUSCORE
AND C.SUBJECTID = D.SUBJECTID
AND A.SUBJECTID = D.SUBJECTID
FROM student_score a, student b, subjectid c
WHERE a.stuno = b.stuno AND
a.subjectid = c.subjectid AND
c.subjectname = 'JavaWeb' AND
a.stuscore BETWEEN 10 AND 60;