一、原题
二、题目翻译
三、题目解析
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
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个)
哪两个语句给出相同的输出?(选择2个)
三、题目解析
AC选项,结果是所有销售过的产品的ID,prod_id.
B和D答案让人容易混淆,B是显示没有销售过的产品ID,但是D答案不等于的连接会导致产品ID全显示出来。
B和D答案让人容易混淆,B是显示没有销售过的产品ID,但是D答案不等于的连接会导致产品ID全显示出来。