(单选题)5: 下面SQL语句中,求每个交易所的平均单价的语句是( )。
A: SELECT 交易所,avg(单价) FROM stock GROUPS BY 单价
B: SELECT 交易所,avg(单价) FROM stock ORDERS BY 单价
C: SELECT 交易所,avg(单价) FROM stock ORDER BY 交易所
D: SELECT 交易所,avg(单价) FROM stock GROUP BY 交易所
正确答案:
(责任编辑:admin)要这答案加QQ:800020900 或加微信:vq800020900 获取 |