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

今日目标：Mysql学习25

实验内容：

--  20.查询所有学号为108.101的同学同年出生的所有学生的s_no,s_name和s_birthday

SELECT * FROM student WHERE YEAR(s_birthday) IN (SELECT YEAR(s_birthday) FROM student WHERE s_no IN('108','101'));

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

| s_no | s_name | s_sex | s_birthday          | s_class |

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

| 101  | 曾华   | 男    | 1977-09-01 00:00:00 | 95033   |

| 102  | 匡明   | 男    | 1975-10-02 00:00:00 | 95031   |

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

| 108  | 张全蛋 | 男    | 1975-02-10 00:00:00 | 95031   |

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