27,580
社区成员
发帖
与我相关
我的任务
分享
--需求实现
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'
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')
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