当前位置:百科知识 > 知到删繁就简答案

问题描述:

[单选] 数据库中存在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
参考答案:查看
答案解析:
☆收藏

随机题目