求出員工性別為1并且數(shù)量大于2的部門名稱
1 回答
慕婉清6462132
TA貢獻1804條經(jīng)驗 獲得超2個贊
select * from departments where ID in(
SELECT departmentid
FROM employees where sex=1 group by departmentid having COUNT(*)>1)
添加回答
舉報
0/150
提交
取消