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 user 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 culumn 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 can not group by the rows of a table by more than one column while using aggregate functions.
------解决方案--------------------
B，C
------解决方案--------------------
c，d？
楼上的给翻译一下吧
b我觉得不对吧，having 子句也可以用吧
------解决方案--------------------
Which two are true about aggregate functions?(Choose two)
关于聚合函数下述那两个是正确的?(选两个)
A.You can use aggregate functions in any clause of a SELECT statement.
-- A 可以在任何条件下的查询语句中使用聚合函数.
B.You can user aggregate functions only in the column list of the SELECT clause and in the WHERE clause of
a SELECT statement.
-- B 只能在包含栏位和Where条件的查询语句中才能使用聚合函数.
C.You can mix single row columns with aggregate functions in the culumn list of a SELECT statement
by grouping on the single row columns.
-- C 可以在包含栏位的以单独的列分组的查询语句中在单独的列上使用聚合函数.
D.You can pass column names,expressions,constants,or functions as parameters to an aggregate function.
-- D 可以将栏位名称,表达式,常量或者函数作为参数传递给聚合函数.
E.You can use aggregate functions on a table,only by grouping the whole table as one single group.
-- 在将整个表分为一个组的情况下可以对表进行聚合.
F.You can not group by the rows of a table by more than one column while using aggregate functions.
-- F.在多于一个栏位的情况下不能使用聚合函数来对一个表的行进行分组.
---
C,D
SELECT SUM(GETDATE()) FROM DUAL WHERE 1=2