Question

表table1中有两个字段：部门ID（departmentid）、员工ID（employerid），请用SQL语句找出拥有10个员工以上

Answer 1

select employerid, departentid from (select count(employerid),departentid,employerid from table1 where group by departentid,employerid having count(employerid)>10)
以上输出的结果是：同一个部门下，员工超过10以上的员工的部门及ID号。

Answer 2

select departmentid as '部门编号',
count(employerid) as '该部门员工数'
from table1 group by departmentid having count(employerid) >10

Answer 3

select departmentid,count(employerid) total from table1
group by departmentid
having count(employerid)>10

Answer 4

select departmentid,count(employerid) total from table1 group by departmentid having total>10