2019-07-10
阅读量:
1315
查询课程编号“002”比“001”课程低的同学的学号姓名
Select S#,Sname
from (select Student.S#,Student.Sname,score ,
(select score from SC SC_2 where SC_2.S#=Student.S# and SC_2.C#='002') score2
from Student,SC
where Student.S#=SC.S# and C#='001') S_2
where score2 < score;
0.0000
0
2
关注作者
收藏
评论(0)
发表评论
暂无数据
