题目内容:
求至少有两个职工的每个仓库的平均工资 ( )
A.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表; HAVING COUNT(*)>=2
B.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表;
GROUP BY仓库号HAVING COUNT(*)>=2
C.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表;
GROUP BY仓库号SET COUNT(*)>=2
D.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表;
GROUP BY仓库号WHERE COUNT(*)>=2
参考答案:
答案解析: