129.View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.

最新推荐文章于 2016-03-23 11:57:15 发布

今年我18

最新推荐文章于 2016-03-23 11:57:15 发布

阅读量897

点赞数

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

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

版权

1z0-051 专栏收录该内容

175 篇文章 1 订阅

订阅专栏

129.View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.
Evaluate the following SQL statement:

SQL>SELECT p.promo_id, p.promo_name, s.prod_id
FROM sales s RIGHT OUTER JOIN promotions p
ON (s.promo_id = p.promo_id);

Which statement is true regarding the output of the above query?
A.It gives the details of promos for which there have been sales.
B.It gives the details of promos for which there have been no sales.
C.It gives details of all promos irrespective of whether they have resulted in a sale or not.
D.It gives details of product ID s that have been sold irrespective of whether they had a promo or not.

答案：C

解析：right join 的用法