问题详情

求至少有两个职工的每个仓库的平均工资


A、SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;

B、HAVING COUNT(*)>=2

C、B.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;

D、GROUP BY 仓库号 HAVING COUNT(*)>=2

E、C.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;

F、GROUP BY 仓库号 SET COUNT(*)>=2

G、D.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;

H、GROUP BY 仓库号 WHERE COUNT(*)>=2

时间:2022-03-22 23:34 关键词:

答案解析

B