132.View the Exhibit and examine the structure of the SALES and PRODUCTS tables.

最新推荐文章于 2016-03-16 15:08:47 发布

今年我18

最新推荐文章于 2016-03-16 15:08:47 发布

阅读量1.1k

点赞数

分类专栏： 1z0-051 文章标签： 1z0-051

本文链接：https://blog.csdn.net/dwj19830118/article/details/50828108

版权

1z0-051 专栏收录该内容

175 篇文章 1 订阅

订阅专栏

132.View the Exhibit and examine the structure of the SALES and PRODUCTS tables.
In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table,
You want to list each product ID and the number of times it has been sold.
Evaluate the following query:

SQL>SELECT p.prod_id, COUNT(s.prod_id)
FROM products p sales s
ON p.prod_id = s.prod_id
GROUP BY p.prod_id;

Which two JOIN options can be used in the blank in the above query to get the required output? (Choose two.)
A.JOIN
B.FULL OUTER JOIN
C.LEFT OUTER JOIN
D.RIGHT OUTER JOIN

答案：BC
解析：题目说列出每一个产品ID，那么可以想到，left join，这里由于sales表中的proid是PRODUCTS表
的外键，因此如果使用full join的话和left join效果是一样的