The ORDERS table has these columns: ORDER_ID NUMBE...
多选题

The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_TOTAL NUMBER(10,2) The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? ()

发布日期:2020-04-10

A.SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;

B.SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;

C.SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;

D.SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;

E.SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;

热门试题

热门资讯

    暂无相关推荐~

分享给好友

分享到朋友圈

取消

使用浏览器的分享功能,把这篇文章分享出去

确定