单选题
VF
题号 #154347
有如下SQL语句:
SELECT SUM(工资) FROM 职工表 WHERE 仓库号 IN;
(SELECT 仓库号 FROM 仓库表 WHERE 所在城市="北京" OR 所在城市="上海")
执行语句后,工资总和是
参考答案
C
答案解析
暂无解析
你可能感兴趣的试题
A.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
HAVING COUNT(*)>=2
HAVING COUNT(*)>=2
B.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
GROUP BY 仓库号 HAVING COUNT(*)>=2
GROUP BY 仓库号 HAVING COUNT(*)>=2
C.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
GROUP BY 仓库号 SET COUNT(*)>=2
GROUP BY 仓库号 SET COUNT(*)>=2
D.SELECT 仓库号,COUNT(*),AVG(工资)FROM 职工表;
GROUP BY 仓库号 WHERE COUNT(*)>=2
GROUP BY 仓库号 WHERE COUNT(*)>=2