10) 查询女员工人数超过3个的部门名称。
select b.DepartmentNamefrom employees a join departments b on a.departmentid=b.departmentID join salary c on a.employeeid=c.employeeid
group by b.DepartmentName
having count(a.sex='false')>3
结果:
消息 102,级别 15,状态 1,第 5 行
'=' 附近有语法错误。
select b.DepartmentNamefrom employees a join departments b on a.departmentid=b.departmentID join salary c on a.employeeid=c.employeeid
group by b.DepartmentName
having count(a.sex='false')>3
结果:
消息 102,级别 15,状态 1,第 5 行
'=' 附近有语法错误。
from employees a join departments b on a.departmentid=b.departmentID join salary c on a.employeeid=c.employeeid
where a.sex='false'
group by b.DepartmentName
having count(1)>3
SELECT b.DepartmentName
FROM employees a
JOIN departments b ON a.departmentid = b.departmentID
JOIN salary c ON a.employeeid = c.employeeid
WHERE a.sex = 'false'
GROUP BY b.DepartmentName
HAVING COUNT(1) > 3