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

今日目标：Mysql学习31

实验内容：

-- 27, 查询选修编号为"3-105"课程且成绩至少高于选修编号为'3-245'同学的c_no,s_no和sc_degree,并且按照sc_degree从高到地次序排序

select * from score where c_no = '3-105' AND sc_degree > ANY(SELECT sc_degree FROM score WHERE c_no = '3-245' ) ORDER BY sc_degree desc ;

 

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

| s_no | c_no  | sc_degree |

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

| 103  | 3-105 |        92 |

| 102  | 3-105 |        91 |

| 101  | 3-105 |        90 |

| 104  | 3-105 |        89 |

| 105  | 3-105 |        88 |

| 109  | 3-105 |        76 |

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