OCP-047 NATURAL JOIN and USING

最新推荐文章于 2021-02-28 12:11:07 发布

原创最新推荐文章于 2021-02-28 12:11:07 发布 · 1.1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#join #structure #less #list #sql

OCP 专栏收录该内容

72 篇文章

订阅专栏

本文探讨了如何使用SQL查询从PRODUCT_INFORMATION和INVENTORIES表中筛选出库存量少于五件的产品，包括产品ID、供应商ID和当前库存量。详细介绍了三种有效的SQL语句，并解释了每种方法的原理。

215. View the Exhibit and examine the structure of the PRODUCT_INFORMATION
and INVENTORIES tables.You have a requirement from the supplies department
to give a list containing PRODUCT_ID,SUPPLIER_ID, and QUANTITY_ON_HAND for
all the products where in QUANTITY_ON_HAND is less than five.

Which two SQL statements can accomplish the task? (Choose two.)

A. SELECT product_id, quantity_on_hand , supplier_id
FROM product_information

NATURAL JOIN inventories AND quantity_on_hand < 5;

B. SELECT i.product_id, i.quantity_on_hand , pi.supplier_id
FROM product_information pi JOIN inventories i

USING (product_id) AND quantity_on_hand < 5;

C. SELECT i.product_id, i.quantity_on_hand , pi.supplier_id
FROM product_information pi JOIN inventories i

ON (pi.product_id=i.product_id) WHERE quantity_on_hand < 5;

D. SELECT i.product_id, i.quantity_on_hand , pi.supplier_id
FROM product_information pi JOIN inventories i
ON (pi.product_id=i.product_id) AND quantity_on_hand < 5;

Answer: CD

题目解释：

1） natural join