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

今日目标：Mysql学习30

实验内容：

-- 26.查询'计算机系'与'电子工程系' 不同职称的教师的name和rof

SELECT * FROM teacher WHERE t_depart = '计算机系' AND t_rof NOT IN (SELECT t_rof FROM teacher WHERE t_depart = '电子工程系')

UNION

SELECT * FROM teacher WHERE t_depart = '电子工程系' AND t_rof NOT IN (SELECT t_rof FROM teacher WHERE t_depart = '计算机系');

 

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

| t_no | t_name | t_sex | t_birthday          | t_rof  | t_depart   |

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

| 804  | 李诚   | 男    | 1958-12-02 00:00:00 | 副教授 | 计算机系   |

| 856  | 张旭   | 男    | 1969-03-12 00:00:00 | 讲师   | 电子工程系 |

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