OCP-1Z0-051-V9.02-114题
来源:互联网 发布:windows to go下载 编辑:程序博客网 时间:2024/05/22 00:50
114. View the Exhibit and examine the structure of the SALES table.
The following query is written to retrieve all those product ID s from the SALES table that have more than
55000 sold and have been ordered more than 10 times.
SQL> SELECT prod_id
FROM sales
WHERE quantity_sold > 55000 AND COUNT(*)>10
GROUP BY prod_id
HAVING COUNT(*)>10;
Which statement is true regarding this SQL statement?
A. It executes successfully and generates the required result.
B. It produces an error because COUNT(*) should be specified in the SELECT clause also.
C. It produces an error because COUNT(*) should be only in the HAVING clause and not in the WHERE
clause.
D. It executes successfully but produces no result because COUNT(prod_id) should be used instead of
COUNT(*).
- OCP-1Z0-051-V9.02-114题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-11题
- OCP-1Z0-051-V9.02-12题
- OCP-1Z0-051-V9.02-14题
- OCP-1Z0-051-V9.02-15题
- OCP-1Z0-051-V9.02-17题
- OCP-1Z0-051-V9.02-18题
- OCP-1Z0-051-V9.02-21题
- OCP-1Z0-051-V9.02-118题
- OCP-1Z0-051-V9.02-120题
- OCP-1Z0-051-V9.02-32题
- OCP-1Z0-051-V9.02-33题
- OCP-1Z0-051-V9.02-93题
- OCP-1Z0-051-V9.02-94题
- OCP-1Z0-051-V9.02-95题
- 点击劫持和图片覆盖劫持
- 黑马程序员-字符编码
- J2EE WEB项目中获取相对路径与绝对路径的方法
- 关于在ie6下相邻的浮动层与绝对定位层不显示的问题
- java反射机制
- OCP-1Z0-051-V9.02-114题
- 使用Eclipse RCP进行桌面程序开发
- PHP冒泡排序详解
- linux 硬软连接ln
- c# 类中的静态方法
- 玩转千万级别的数据(二)
- mongodb 固定集合和GridFS
- atoi函数的实现
- ZENCART 网站滚动条修改