A.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表; HAVINGCOUNT(*)>=2
B.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表; GROUPBY仓库号HAVING COUNT(*)>=2
C.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表; GROUPBY仓库号SET COUNT(*)>=2
D.SELECT仓库号,COUNT(*),AVG(工资)FROM职工表; GROUPBY仓库号WHERE COUNT(*)>=2
[单选题]求至少有两个职工的每个仓库的平均工资A.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表; HAVING COUNT(*)>=2B.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表; GROUP BY 仓库号 HAVING COUNT(*)>=2C.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表; GROUP BY 仓库号 SET COUNT(*)>=2D.SELECT 仓库号,COUNT(*),AVG(工资)
[单选题]求至少有两个职工的每个仓库的平均工资A.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;H.AVING COUNT(*)>=2B.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;G.ROUP BY 仓库号 HAVING COUNT(*)>=2C.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;G.ROUP BY 仓库号 SET COUNT(*)>=2D.SELECT 仓库号,COUNT(*),AVG(工资)
[单选题]求至少有4个职工的每个仓库的工资总和( )。A.SELECT 仓库号,COUNT(*),SUM(工资) FROM 职工; WHERE COUNT(*)>=4B.SELECT 仓库号,COUNT(*),SUM(工资) FROM 职工; GROUP BY 仓库号 SET COUNT(*)>=4C.SELECT 仓库号,COUNT(*),SUM(工资) FROM 职工; GROUP BY 仓库号 HAVING COUNT(*)>=4D.SELECT 仓库号,COUNT(*),SUM(工资) FROM
[试题]假设有职工表(职工号,仓库号,工资),将下面的SQL语句补充完整,求至少有两个职工的每个仓库的平均工资。SELECT仓库号,COUNT(﹡),AVG(工资)FROM职工;G.ROUP BY仓库号__________COUNT(﹡)>=2
[单选题]检索最少有4名职工仓库的职工平均工资( )。A.SELECT 仓库号,COUNT(*) AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 仓库号 WHERE COUNT(*)>=4B.SELECT 仓库号,COUNT(*) AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 仓库号 HAVING COUNT(*)>=4C.SELECT 仓库号,COUNT(*) AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 职工号 W
[单选题]检索最少有4名职工仓库的职工平均工资( )。A.SELECT 仓库号,COLINT(*) AS 人数,AVG(工资) AS 平均工资 FROM 职工; GROUP BY 仓库号 WHERE COUNT(*)>=4B.SELECT 仓库号,COUNT(*) AS 人数,AVG(工资) AS 平均工资 FROM 职工; GROUP BY 仓库号 HAVING COUNT(*)>=4C.SELECT 仓库号,COUNT(*) AS 人数,AVG (工资) AS 平均工资 FROM 职工; GROUP
[单选题]检索最少有4名职工的仓库的职工平均工资( )。A.)SELECT仓库号,COUNT(﹡)AS人数,AVG(工资)AS平均工资FROM职工;G.ROUP BY仓库号WHERE COUNT(﹡)>=4B.)SELECT仓库号,COUNT(﹡)AS人数,AVG(1资)AS平均工资FROM职工;G.ROUP BY仓库号HAVING COUNT(﹡)>=4C.)SELECT仓库号,COUNT(木)AS人数,AVG(工资)AS平均工资FROM职工;G.ROUP BY职工号WHERE COUNT(
[单选题]检索最少有4名职工仓库的职工平均工资的语句为( )。A.SELECT 仓库号,COUNT(*) AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 仓库号 WHERE COUNT(*)>=4B.SELECT 仓库号,COUNT(*) AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 仓库号 HAVING COUNT(*)>=4C.SELECT 仓库号,COUNT(*) AS人数,AVG(工资) AS 平均工资 FROM 职工; GROUPBY 职
[主观题]每个尺寸链中至少有两个或两个以上的组成环。()
[单选题]已知两个同类型企业职工平均工资的标准差分别为8元,12元,则两个企业职工平均工资的代表性是()。A . 甲大于乙B . 乙大于甲C . 一样的