问题描述:
[单选]
数据库中存在Orders(OrderDate,OrderPrice,Customer)表,其中OrderDate为订单日期,OrderPrice为订单金额,Customer为客户,现在要查找出订单总金额少于2000的客户,则可以使用哪条SQL语句()
A.SELECT Customer,SUM(OrderPrice)from Orders WHERE SUM(OrderPrice)<2000 GROUP BY Customer
B.SELECT Customer,COUNT(OrderPrice)from Orders GROUP BY Customer HAVING COUNT(OrderPrice)<2000
C.SELECT Customer,COUNT(OrderPrice)from Orders HAVING COUNT(OrderPrice)<2000 GROUP BY Customer
D.SELECT Customer,SUM(OrderPrice)from Orders GROUP BY Customer HAVING SUM(OrderPrice)<2000
参考答案:查看无
答案解析:无
☆收藏
答案解析:无
☆收藏
- 我要回答: 网友(216.73.216.57)
- 热门题目: 1.新版快速检查单中,符合执行“ 2.当执行安定面失控非正常检查单 3.在安定面失控条件下,非正常检
