sql语句练习50题(Mysql版)--我的答案
1、查询"01"课程比"02"课程成绩高的学生的信息及课程分数
select s.*,s1.s_score,s2.s_score from student s, score s1,score s2 where s.s_id=s1.s_id and s1.s_id=s2.s_id and s1.c_id=‘01’ and s2.c_id=‘02’ and s1.s_score>s2.s_sco...
原创
2019-07-07 14:41:21 ·
704 阅读 ·
0 评论