问题详情

Which two are true about aggregate functions?()


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.

时间:2022-05-21 00:18 关键词: 1Z0-007

答案解析

C | D