18.Examine the structure of the PROMOTIONS table:

最新推荐文章于 2023-05-04 09:36:45 发布

今年我18

最新推荐文章于 2023-05-04 09:36:45 发布

阅读量1k

点赞数

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

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

版权

1z0-051 专栏收录该内容

175 篇文章 1 订阅

订阅专栏

18.Examine the structure of the PROMOTIONS table:
name Null Type
PROMO_ID NOT NULL NUMBER(6)
PROMO_NAME NOT NULL VARCHAR2(30)
PROMO_CATEGORY NOT NULL VARCHAR2(30)
PROMO_COST NOT NULL NUMBER(10,2)
The management wants to see a report of unique promotion costs in each promotion category.
Which query would achieve the required result?
A：SELECT DISTINCT promo_cost, promo_category FROM promotions;
B：SELECT promo_category, DISTINCT promo_cost FROM promotions;
C：SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;
D：SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
答案：D
解析：考察distinct，参考 14题，BC不正确，题目说是要求唯一的promotion costs，其实AD都可以的，
如果非要选择一个的话，D是显示目录，后面是价格。显示比较友好，A和D就是显示和排序不一样