多表连接

[a_pei]

student表中有字段：sno.ssex,class,sname,sbirthday
course表中有字段：cno,cname,tno
score表中有字段：sno,cno,degree
teacher表中有字段：tno,tname,tsex,trof,tbirthday,depart

查询选修“3-105”课程的成绩高于“109”号同学成绩的所有同学的记录

[steven_0825]

select t1.* from stutent t1,course t2,score t3 where t1.sno=t3.sno and t2.cno=t3.cno and t3.cno='3-105' and t3.degree>=95
自己环境试试

[steven_0825]

select t1.* from stutent t1,course t2,score t3 where t1.sno=t3.sno and t2.cno=t3.cno and t3.cno='3-105' and t3.degree>=105

[abcdef1111111]

楼主给个例子啊，不给例子怎么知道你要什么样的记录啊

[橡胶轮胎行业数字化高总]

缺少字段说明啊，让我猜？

[abcdef1111111]

select s.sno,s.sex.s.class.s.sname,s.sbirthday 
from student s,course c,score sc 
where c.cname='3-105' and sc.degree> (select sc.degree from sc,s,c where s.sno=sc.sno and sno='109' and c.cno=s.cno and c.cname='3-105')

我没环境测试，楼主可以试试

[guoying_]

顶起。。。

[sql_lover]

--需求实现
SELECT a.*,b.degree FROM student a, INNER JOIN score b ON a.sno=b.sno inner join course c ON b.cno=c.cno
WHERE b.degree >109 AND c.cno = '3-105'

[chuanzhang5687]

select * from student inner join score on student.sno=score.sno
where cno='3-105'and
degree>(select degree from score where sno=109 and cno='3-105')