SQL语句 SELECT 部门表.部门号,部门名称,SUM(单价*数量), FROM 部门表,商品表; WHERE 部门表,部门号=商品表.部门号; GROUP BY 部门表. 部门号 查询结果为 ______。
A.
各部门商品数量合计
B.
各部门商品金额合计
C.
所有商品金额合计
D.
各部门商品金额平均值
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
微信内点击右上角“…”即可分享
反馈
参考答案:
举一反三
【简答题】用所给动词的适当形式填空 小题1:Look, there are so many people over there. What ____(happen)? 小题2:It’s seven in the morning. It’s time for us ____(go) to school. 小题3:Look at the clouds in the sky. I think it ____(ra...
【简答题】单词拼写 用所给动词的适当形式填空 小题1:Look, there are so many people over there. What ____(happen)? 小题2:It’s seven in the morning. It’s time for us ____(go) to school. 小题3:Look at the clouds in the sky. I think it __...