2020/11/19 刘一辰的JAVA随笔

今日目标：Mysql学习23

实验内容：

-- 18.查询选修"3-105"课程的成绩高于'109'号同学'3-105'成绩 的所有同学的记录

(在大家都在选修3-105的背景下 查询 所有 分数 比 学号为"109"还要高的学生信息)

SELECT * FROM student AS s, score AS sc WHERE sc.c_no = '3-105' AND sc.sc_degree > (SELECT sc_degree FROM score WHERE s_no = '109' AND c_no = '3-105') AND s.s_no = sc.s_no;

 

 

+------+--------+-------+---------------------+---------+------+-------+-----------+

| s_no | s_name | s_sex | s_birthday          | s_class | s_no | c_no  | sc_degree |

+------+--------+-------+---------------------+---------+------+-------+-----------+

| 103  | 王丽   | 女    | 1976-01-23 00:00:00 | 95033   | 103  | 3-105 |        92 |

| 105  | 王芳   | 女    | 1975-02-10 00:00:00 | 95031   | 105  | 3-105 |        88 |

+------+--------+-------+---------------------+---------+------+-------+-----------+