[求助]同时包含多个数的查询

andymark

SELECT a.部门
FROM [SELECT DISTINCT 表1.部门, 表1.年龄 FROM 表1 WHERE 表1.年龄 in (20,30)]. AS a
GROUP BY a.部门
HAVING count(a.部门)>1;