Which two are true about aggregate functions? (Choose two.)

Question

Options

• AYou can use aggregate functions in any clause of a SELECT statement.
• BYou can use aggregate functions only in the column list of the SELECT clause and in the WHERE
• CYou can mix single row columns with aggregate functions in the column list of a SELECT statement
• DYou can pass column names, expressions, constants, or functions as parameters to an aggregate
• EYou can use aggregate functions on a table, only by grouping the whole table as one single group.
• FYou cannot group the rows of a table by more than one column while using aggregate functions.

• A
  3% (1)
• B
  9% (3)
• C
  82% (27)
• F
  6% (2)

Explanation

It is possible to mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns. Also it is acceptable to pass column names, expressions, constraints, or other functions as parameters to an aggregate function. Incorrect Answers A: You cannot use aggregate functions in any clause of a SELECT statement. For example, they cannot be used with a WHEN statement. B: It is not possible to use aggregate functions in the WHERE clause of a SELECT statement. But they can be used with a HAVING clause used after the GROUP BY clause, for example. E: You don't need to group the whole table as one single group. F: It is possible to group more than one column while using aggregate functions.

No community discussion yet for this question.