一道面试题，求解释啊

[supergrape]

表 EMP
字段 name , dep , salary

求部门人员大于10的部门工资总和

[hao1hao2hao3]

SELECT DEP,SUM(SALARY)
FROM EMP
GROUP BY DEP 
HAVING COUNT(NAME) > 10

[supergrape]

想了1分钟没想出来，结果就悲剧了，看来还是写的少啊~

[hc129]

select sum(salary) from emp where dept in (select dep from emp group by dep having count(*) >10);

[dawugui]

select dep , sum(salary) from emp group by name having count(1) > 10

[南湖少主]

差不多就这样吧！你这个题目没说的太清！
select top 10 name,dep,sum(salary) from EMP group by name,dep

[guye1986]

SELECT deptno 部门编号,SUM(sal) 工资总数,COUNT(*) 部门人数 FROM emp
GROUP BY deptno
HAVING COUNT(*)>10

[supergrape]

[Quote=引用 5 楼 t1008 的回复:]
差不多就这样吧！你这个题目没说的太清！
select top 10 name,dep,sum(salary) from EMP group by name,dep
[/Quote]
部门人数大于10个的部门的工资总和 ， 1楼的答案就能够实现~

[veval]

1楼正解！

[chcchb]

SELECT DEP,SUM(SALARY)
FROM EMP
GROUP BY DEP 
HAVING COUNT(DEP) > 10

[Ade子夜]

[Quote=引用 4 楼 dawugui 的回复:]

SQL code
select dep , sum(salary) from emp group by name having count(1) > 10
[/Quote]
顶