OCP-1Z0-新051-61题版本-34
来源:互联网 发布:网络带来的弊端 编辑:程序博客网 时间:2024/06/05 15:22
QUESTION NO: 34
Which two statements are true regarding the COUNT function? (Choose two.)
A. COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns
B. COUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column
C. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column
D. A SELECT statement using COUNT function with a DISTINCT keyword cannot have a WHERE clause
E. The COUNT function can be used only for CHAR, VARCHAR2 and NUMBER data types
Answer: A,C
答案解析:
参考:108:http://blog.csdn.net/rlhua/article/details/11973833
Explanation:
Using the COUNT Function
The COUNT function has three formats:
COUNT(*)
COUNT(expr)
COUNT(DISTINCT expr)
COUNT(*) returns the number of rows in a table that satisfy the criteria of the SELECT statement,
including duplicate rows and rows containing null values in any of the columns. If a WHERE
clause is included in the SELECT statement, COUNT(*) returns the number of rows that satisfy the
condition in the WHERE clause.
In contrast,
COUNT(expr) returns the number of non-null values that are in the column identified by expr.
COUNT(DISTINCT expr) returns the number of unique, non-null values that are in the column
identified by expr.
- OCP-1Z0-新051-61题版本-34
- OCP-1Z0-新051-61题版本-61
- OCP-1Z0-新051-61题版本-1
- OCP-1Z0-新051-61题版本-2
- OCP-1Z0-新051-61题版本-3
- OCP-1Z0-新051-61题版本-4
- OCP-1Z0-新051-61题版本-5
- OCP-1Z0-新051-61题版本-6
- OCP-1Z0-新051-61题版本-7
- OCP-1Z0-新051-61题版本-8
- OCP-1Z0-新051-61题版本-9
- OCP-1Z0-新051-61题版本-10
- OCP-1Z0-新051-61题版本-11
- OCP-1Z0-新051-61题版本-12
- OCP-1Z0-新051-61题版本-13
- OCP-1Z0-新051-61题版本-14
- OCP-1Z0-新051-61题版本-15
- OCP-1Z0-新051-61题版本-16
- 【android,23】手势识别的开发
- Celery 分发任务
- 120 - Stacks of Flapjacks
- 【Node】node启动过程
- ubuntu 13.04 初探笔记
- OCP-1Z0-新051-61题版本-34
- 2013年度总结
- OCP-1Z0-新051-61题版本-35
- 丑数(humble number) hdu 1058 DP
- OCP-1Z0-新051-61题版本-36
- 【LeetCode】Single Number
- 游戏服务端之AOI概述
- 什么是增量检查点?
- OCP-1Z0-新051-61题版本-37