一、原题
二、题目翻译
三、题目解析
View the Exhibit and examine the data in the PROMOTIONS table.
![](https://img-blog.csdn.net/20140520084403171?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaG9sbHkyMDA4/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast)
You need to display all promo categories that do not have 'discount' in their subcategory.
Which two SQL statements give the required result? (Choose two.)
A. SELECT promo_category
FROM promotions
MINUS
SELECT promo_category
FROM promotions
WHERE promo_subcategory = 'discount';
B. SELECT promo_category
FROM promotions
INTERSECT
SELECT promo_category
FROM promotions
WHERE promo_subcategory = 'discount';
C. SELECT promo_category
FROM promotions
MINUS
SELECT promo_category
FROM promotions
WHERE promo_subcategory <> 'discount';
D. SELECT promo_category
FROM promotions
INTERSECT
SELECT promo_category
FROM promotions
WHERE promo_subcategory <> 'discount';
答案:AD
You need to display all promo categories that do not have 'discount' in their subcategory.
Which two SQL statements give the required result? (Choose two.)
A. SELECT promo_category
FROM promotions
MINUS
SELECT promo_category
FROM promotions
WHERE promo_subcategory = 'discount';
B. SELECT promo_category
FROM promotions
INTERSECT
SELECT promo_category
FROM promotions
WHERE promo_subcategory = 'discount';
C. SELECT promo_category
FROM promotions
MINUS
SELECT promo_category
FROM promotions
WHERE promo_subcategory <> 'discount';
D. SELECT promo_category
FROM promotions
INTERSECT
SELECT promo_category
FROM promotions
WHERE promo_subcategory <> 'discount';
答案:AD
二、题目翻译
查看 PROMOTIONS表的数据
要显示所有子种类中没有'discount'的促销种类.
下面哪两个SQL语句能给出正确的结果?(选择2个)
要显示所有子种类中没有'discount'的促销种类.
下面哪两个SQL语句能给出正确的结果?(选择2个)
三、题目解析
MINUS 表示两个结果集相减
INTERSECT 表示两个结果集的交集,即两个结果集中共有的部分。
A选项正确,从所有种类中,减去子种类= 'discount'的,就表示没有这个子种类的。
B选项不正确,所有种类和子种类= 'discount'的交集,就是子种类= 'discount'的产品,不符合题目要求。
C选项不正确,从所有种类中,减去 子种类<> 'discount'的,就是子种类= 'discount'的产品,不符合题目要求。
D选项正确,所有种类和子种类<> 'discount'的交集,就是子种类<>'discount'的产品。
INTERSECT 表示两个结果集的交集,即两个结果集中共有的部分。
A选项正确,从所有种类中,减去子种类= 'discount'的,就表示没有这个子种类的。
B选项不正确,所有种类和子种类= 'discount'的交集,就是子种类= 'discount'的产品,不符合题目要求。
C选项不正确,从所有种类中,减去 子种类<> 'discount'的,就是子种类= 'discount'的产品,不符合题目要求。
D选项正确,所有种类和子种类<> 'discount'的交集,就是子种类<>'discount'的产品。