OCP-1Z0-051-V9.02-143题

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');

Answer: C

答案解析:

参考:http://blog.csdn.net/rlhua/article/details/12879585

显示在最后一个promo之后并且category为INTERNET开始的所有promos的promo name和start date。

A,promo_category = 'INTERNET'应该再子查询里面。

B,条件不满足,条件要求找出最后一个promo之后并且category为INTERNET开始的所有promos的promo name和start date。

C,正确,大于ALL,即是大于最大值。

D,错误,大于ANY,即是大于最小值。


  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值