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 parameter 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.
正确答案:A,E
答案解析:有
微信扫一扫手机做题