试题详情
多项选择题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.

  • C,D
  • 关注下方微信公众号,在线模考后查看

热门试题