OCP-1Z0-051 补充题库 第32题 ALL、ANY、IN

一、原题

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

二、题目翻译

下面是 PROMOTIONS表的结构。
要生成一个报表，显示所有种类为'INTERNET'，并且在最后的活动之后开始的活动的名称、开始日期。
下面哪一个能得到想要的结果？

三、题目解析

> ALL 表示大于最大值
> ANY 表示大于最小值
根据题意，要找出promo_begin_date大于所有活动的最大promo_begin_date的活动。