测测你，一条简单的题目

[bdld1983]

数据库中有clerk表：
员工编号 职务 组织编码
userid position deptid
要求：取出部门员工数>10人的组织，查询语句是什么？

[ask_chang]

sql server 2000

select distinct 组织编码
from clerk
group by 组织编码
having count( distinct 员工编号)>10

[nightmaple]

[Quote=引用楼主 bdld1983 的回复:]
数据库中有clerk表：
员工编号 职务 组织编码
userid position deptid
要求：取出部门员工数>10人的组织，查询语句是什么？
[/Quote]

select * from clerk where deptid in
(select deptid from clerk group by deptid having count(*)>10)

[ChinaITOldMan]

select 组织编码 from clerk
group by 组织编码
having count(1)>10

[jcl19840702]

不懂，学习

[DingZaL]

~~~~~~

[ChinaJiaBing]

--try

select 员工编号,职务,组织编码
          from clerk group by 员工编号,职务,组织编码 having (count(员工编号)>10)

[yuna@liu]

userid position deptid

select deptid,count(deptid) from  clerk group by deptid having count(deptid)>10

[droider]

select deptid
from clerk
group by deptid
having count(userid) > 10

[老黎]

学习.

[helinhai]

每天回帖即可获得10分可用分！小技巧

[ayfwz]

xuexi中，谢谢

[ayfwz]

挣点积分

[lilibaobao]

[Quote=引用 2 楼 brownhwy 的回复:]
SQL code
select deptid from clerk group by deptid having count(userid) >10
[/Quote]
正确

[cxmcxm]

select distinct deptid from clerk a
where (select count(*) from clerk where deptid=a.deptid)>10

[nongfucha]

不息体力.......扫帖

[ssh87]

思路：1，按部门分组
2。人数大于10
select deptid from clerk group by deptid having count(userid) >10

[luckhanjie]

学习，帮忙顶了

[kingboyrang]

顶顶学习中。。。

[renfengliu456]

select deptid,count(userid) from clerk
group by deptid
having count(userid)>10

[shixixi1987]

[Quote=引用楼主 bdld1983 的回复:]
数据库中有clerk表：
员工编号 职务 组织编码
userid position deptid
要求：取出部门员工数>10人的组织，查询语句是什么？