Q: 144 Which two are true about aggregate functions? (Choose two.)A. You can use aggregate functions in any clause of a SELECT statement.
B. You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause
of a SELECT statement.
C. You can mix single row columns with aggregate functions in the column list of a SELECT statement by
grouping on the single row columns.
D. You can pass column names, expressions, constants, or functions as parameters to an aggregate function.
E. You can use aggregate functions on a table, only by grouping the whole table as one single group.
F. You cannot group the rows of a table by more than one column while using aggregate functions.
Answer: C, D我看懂了A、B、C选项内容的意思,问下DEF选项是啥意思?
B. You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause
of a SELECT statement.
C. You can mix single row columns with aggregate functions in the column list of a SELECT statement by
grouping on the single row columns.
D. You can pass column names, expressions, constants, or functions as parameters to an aggregate function.
E. You can use aggregate functions on a table, only by grouping the whole table as one single group.
F. You cannot group the rows of a table by more than one column while using aggregate functions.
Answer: C, D我看懂了A、B、C选项内容的意思,问下DEF选项是啥意思?
解决方案 »
- ora-01017 invalid username/password;logon denied
- 请问用PLSQL连接远程Orc数据库问什么在测试的时候不成功,而且还报乱码错误尼?
- EXECUTE IMMEDIATE 结果返回问题
- 为什么单点登录(sso)页面,第一次密码输入错误,再次输入也进不去?
- 求一条SQL语句
- 急急急急!!!!!
- 为何启动ManagementServer 老是报错!
- Sharing knowledge
- 如何设置ORACLE中的sequences的初始值,因为我不想从1开始增加,而是想从动态值开始。
- 被防火墙隔离的两个数据库中的两张表如可何实现定时同步?50分送上
- 有关于建同义词的原因理解!
- inner query 、outer query 啥意思呢?
E : 只有当你把整个表作为一个组的时候,聚合函数才能使用
F : 当用聚合函数的时候,你不能把一个表的2个或多个列分组(就是group by 不能有2或多个列)个人之见~~