![](https://lstatic.shangxueba.com/sxbzda/h5/images/m_q_title.png)
足缺料分析表不能考虑的仓库类型是()
A.实仓
B. 待检仓
C. 代管仓
D. 赠品仓
![](https://lstatic.shangxueba.com/sxbzda/h5/images/tips_org.png)
第5题
A.SELECT * FROM 仓库表 WHERE IN; (SELECT 仓库号 FROM 职工表)
B.SELECT * FROM 仓库表 WHERE NOT IN; (SELECT 仓库号 FROM 职工表)
C.SELECT * FROM 仓库表 WHERE 仓库号 EXISTS; (SELECT * FROM 职工表 WHERE 仓库号=仓库表.仓库号)
D.SELECT * FROM 仓库表 WHERE EXISTS; (SELECT * FROM 职工表 WHERE 仓库号=仓库表.仓库号)
第6题
A.SELECT*FROM仓库表WHERE IN; (SELECT仓库号FROM职工表)
B.SELECT*FROM仓库表WHERE NOT IN; (SELECT仓库号FROM职工表)
C.SELECT*FROM仓库表WHERE仓库号EXISTS; (SELECT*FROM职工表WHERE仓库号=仓库表.仓库号)
D.SELECT*FROM仓库表WHERE EXISTS; (SELECT*FROM职工表WHERE仓库号=仓库表.仓库号)
第8题
A.SELECT。FROM仓库表WHEREIN; (SELECT仓库号FROM职工表)
B.SELECT 2p FROM仓库表WHERENOTm; (SELECT仓库号FROM职工表)
C.SELECT::FROM仓库表WHERE仓库号EXISTS; (SELECT*FROM职工表WHERE仓库号:仓库表.仓库号)
D.SELECT*FROM仓库表WHEREEXISTS; (SEL。E(:T*FROM职工表WHERE仓库号:仓库表.仓库号)
第9题
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
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!