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

今日目标：Mysql12

实验内容：

-- 5.查询score表中成绩为85, 86, 或者88的记录(sc_degree)

 

SELECT * FROM score WHERE sc_degree IN(85, 86, 88);

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

| s_no | c_no  | sc_degree |

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

| 103  | 3-245 |        86 |

| 103  | 6-166 |        85 |

| 105  | 3-105 |        88 |

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