OCP-1Z0-051 补充题库第32题 ALL、ANY、IN_you have to generate a report that displays the pr-CSDN博客

本文链接：https://blog.csdn.net/holly2008/article/details/34993989

本文详细解析了如何使用SQL的ALL、ANY、IN操作符来解答Oracle OCP认证考试中的一个问题。具体情境是找出所有在'INTERNET'类别中，开始日期晚于该类别内所有活动最大开始日期的促销活动。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、原题

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的活动。