OCP-1Z0-051 第153题 集合操作和JOIN

一、原题

View the Exhibits and examine the structures of the PRODUCTS and SALES tables.

Which two SQL statements would give the same output? (Choose two.)
A. SELECT prod_id FROM products
     INTERSECT
     SELECT prod_id FROM sales;

B. SELECT prod_id FROM products
      MINUS
    SELECT prod_id FROM sales;

C. SELECT DISTINCT  p.prod_id
       FROM products p JOIN sales s
            ON p.prod_id=s.prod_id;

D. SELECT DISTINCT p.prod_id
        FROM products p JOIN sales s
             ON p.prod_id <> s.prod_id;

答案：AC

二、题目翻译

查看PRODUCTS and SALES表的结构：
哪两个语句给出相同的输出？（选择2个）

三、题目解析

AC选项，结果是所有销售过的产品的ID，prod_id.
B和D答案让人容易混淆，B是显示没有销售过的产品ID，但是D答案不等于的连接会导致产品ID全显示出来。