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

最新推荐文章于 2022-05-10 15:33:49 发布
原创 最新推荐文章于 2022-05-10 15:33:49 发布 · 6.9k 阅读 · 1 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文深入解析一个SQL查询语句，该语句利用嵌套子查询来筛选特定条件下的产品ID。通过展示具体的SQL语句执行过程和结果，帮助读者理解如何在SQL查询中运用复杂的条件过滤机制。

149. View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.

Evaluate the following SQL statement:

SQL> SELECT prod_id FROM costs  

WHERE promo_id IN  (SELECT promo_id FROM promotions                      

WHERE promo_cost < ALL                    

(SELECT MAX(promo_cost) FROM promotions                      

GROUP BY (promo_end_date-                                 

promo_begin_date)));

What would be the outcome of the above SQL statement?

A. It displays prod IDs in the promo with the lowest cost.

B. It displays prod IDs in the promos with the lowest cost in the same time interval.

C. It displays prod IDs in the promos with the highest cost in the same time interval.

D. It displays prod IDs in the promos with cost less than the highest cost in the same time interval.

Answer: D

 

答案解析：

1、首先查询出promo_end_date- promo_begin_date期间promo_cost的最大值

sh@TEST0924> SELECT MAX(promo_cost) FROM promotions
  2  GROUP BY (promo_end_date- promo_begin_date);
 
MAX(PROMO_COST)
---------------
              0
          98500
              0
          99900
         100000
          99000
          99300
          95900
          99600
          98000
 
10 rows selected.
 
2、<ALL，即小于1查询出来所有的的值，即小于最小值。
3、按题中查询，即查询出小于MAX(promo_cost) 的所有的值。
sh@TEST0924>  SELECT prod_id FROM costs
  2  WHERE promo_id IN  (SELECT promo_id FROM promotions
  3  WHERE promo_cost < ALL
  4  (SELECT MAX(promo_cost) FROM promotions
  5  GROUP BY (promo_end_date-
  6  promo_begin_date)));
 
 
no rows selected
 
OCP-1Z0-051-V9 02-96题
qq_43679940的博客
02-25 334
OCP-1Z0-051-V9 02-96题
OCP-1Z0-051 第149题 子查询中ALL的应用
Oracle
05-22 4223
一、原题 View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables. Evaluate the following SQL statement: SQL>SELECT prod_id   FROM costs  WHERE promo_id IN        (SELECT prom
149.View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.
dwj19830118的专栏
03-10 1175
149.View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.
1z0-071 Oracle Database 12c SQL 第72题 less than the highest
点滴的幸福
06-24 965
Q72. View the exhibits and examine the structures of the COSTS and PROMOTIONS tables.Evaluate the following SQL statement:SQL&gt; SELECT prod_id FROM costsWHERE promo_id IN (SELECT promo_id FROM promo...
Oracle 19c OCP 1Z0-082认证考试题库（51-60）
姚远OracleACE的博客
05-10 2650
51.View the Exhibit and examine the description of the tables You execute this SQL statement Which three statements are true? A.The sales table has five foreign keys B.The statement will execute successfully and a new row will be inserted into the SALES ta
ocp 1Z0-051 141-175题解析
Database、Code
12-11 7726
141. View the Exhibitand examine the structure of CUSTOMERS and GRADES tables. You need to displaynames and grades of customers who have the highest credit limit. Which two SQL statementswould accom
OCP-1Z0-051-V9 02-32题
sdfsdkk的博客
02-21 370
OCP-1Z0-051-V9 02-32题
OCP-1Z0-051-V9.02-1题
热门推荐
一抹曦阳-Oracle
09-30 1万+
1. View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables. The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.
OCP-1Z0-051-V9.02-14题
一抹曦阳-Oracle
09-02 9957
14. Using the CUSTOMERS table,  you need to generate a report that shows 50% of each   credit amount in each income level. The report should NOT show any repeated credit amounts in each income l
OCP-1Z0-051 第168题 使用子查询DELETE数据
Oracle
05-25 4141
一、原题 View the Exhibit and examine the description of SALES and PROMOTIONS tables. You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has either blowout
120.View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS
dwj19830118的专栏
03-07 1059
120.View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS
123.View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS
dwj19830118的专栏
03-07 1577
123.View the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS
129.View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.
dwj19830118的专栏
03-08 986
129.View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.
100.View the Exhibit and examine the structure of the PROMOTIONS table.
dwj19830118的专栏
03-04 1936
100.View the Exhibit and examine the structure of the PROMOTIONS table.
61.View the Exhibit and examine the structure of the PROMOTIONS table.
dwj19830118的专栏
03-01 1114
61.View the Exhibit and examine the structure of the PROMOTIONS table.
91.View the Exhibit and examine the structure of the PROMOTIONS table. Which two SQL statements woul
dwj19830118的专栏
12-22 2096
91.View the Exhibit and examine the structure of the PROMOTIONS table. Which two SQL statements woul
56.View the Exhibit and examine the structure of the PROMOTIONS table.
dwj19830118的专栏
02-29 1474
56.View the Exhibit and examine the structure of the PROMOTIONS table.
OCP-1Z0-051 第118题 GROUP BY,HAVING子句
Oracle
05-13 4743
一、原题 View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL statements: Statement 1 SQL>SELECT promo_category,SUM(promo_cost)    FROM promotions    W
OCP-1Z0-051-V9.02-123题
一抹曦阳-Oracle
10-19 1万+
123. View the Exhibits  and examine the structures of the PRODUCTS, SALES,  and CUSTOMERS tables. You need to generate a report that gives details of the customer's last name, name of the product,  
OCP-1Z0-051-V9.02-60题
一抹曦阳-Oracle
09-20 7814
60. View the Exhibit and examine the structure of CUSTOMERS table. Evaluate the following query: SQL>SELECT cust_id, cust_city     FROM customers     WHERE cust_first_name NOT LIKE 'A_%g_%' AN
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值