检索最少有3名职工的每个部门的职工工资总额A.SELECT 部门号,COUNT(*)
问题:
检索最少有3名职工的每个部门的职工工资总额
A.SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
HAVING COUNT(*)>=3
B.SELECT 部门号,COUNT(*),SUM(工资)FROM职工表;
GROUP BY 部门号 HAVING COUNT(*)>=3
C.SELECT 部门号,COUNT(*),SUM(工资)FROM 职工表;
GROUP BY 部门号 SET COUNT(*)>=3
D.SELECT 部门号,COUNT(*),SUM(工资)FROM职工表;
GROUP BY 部门号 WHERE COUNT(*)>=3