143.View the Exhibit and examine the structure of the PROMOTIONS table.

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

今年我18

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

阅读量1.1k

点赞数

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

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

版权

1z0-051 专栏收录该内容

175 篇文章 1 订阅

订阅专栏

143.View the Exhibit and examine the structure of the PROMOTIONS table.
You have to generate a report that displays the promo name and start date for all promos that started after

the last promo in the 'INTERNET' category.

Which query would give you the required output?
A.SELECT promo_name, promo_begin_date FROM promotions
WHERE promo_begin_date > ALL (SELECT MAX(promo_begin_date) FROM promotions )AND
promo_category = 'INTERNET';
B.SELECT promo_name, promo_begin_date FROM promotions
WHERE promo_begin_date IN (SELECT promo_begin_date
FROM promotions
WHERE promo_category='INTERNET');
C.SELECT promo_name, promo_begin_date FROM promotions
WHERE promo_begin_date > ALL (SELECT promo_begin_date
FROM promotions
WHERE promo_category = 'INTERNET');
D.SELECT promo_name, promo_begin_date FROM promotions
WHERE promo_begin_date > ANY (SELECT promo_begin_date
FROM promotions
WHERE promo_category = 'INTERNET');
答案：C
解析：题目说是时间在所有的promo_category = 'INTERNET'时间的后面，因此首先排除A（这个promo_category = 'INTERNET'的位置错了）
，B（这个是相等），D(这个不是所有）