下面的sql的意思是找到所有非技术部的员工的id,code和name
https://www.jb51.net/article/214476.htm
SELECT a.* FROM(
select ID from question where QUESTION_TYPE = 14
UNION ALL
select QUESTION_ID AS ID from question_option where CONTENT = '错'
)a GROUP BY a.id HAVING COUNT(a.id)=1
