OCP 071--45

最新推荐文章于 2020-01-17 16:08:16 发布

原创最新推荐文章于 2020-01-17 16:08:16 发布 · 350 阅读

0 ·

CC 4.0 BY-SA版权

本文探讨了在SQL中如何正确使用DELETE语句从ORDER_ITEMS表中删除那些在ORDERS表中状态为0或1的行。通过对比四个不同的DELETE语句，最终确定了两个有效的SQL语句（选项A和D），并解释了为什么其他选项不适用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.
You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1
in the ORDERS table.
Which two DELETE statements are valid? (Choose two.)
A) DELETE
FROM order_items
WHERE order_id IN (SELECT order_id
FROM orders
WHERE order_status in (0,1));
B) DELETE *
FROM order_items
WHERE order_id IN (SELECT order_id
FROM orders
WHERE order_status IN (0,1));
C) DELETE
FROM (SELECT * FROM order_items i,orders o
WHERE i.order_id = o.order id AND order_status IN (0,1));
D) DELETE FROM order_items i
WHERE order_id = (SELECT order_id FROM orders o
WHERE i.order_id = o.order_id AND order_status IN (0,1));