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 mix single row columns with aggregate functions in the column list of a SELECT
statement by grouping on the single row columns.
C.
You can use aggregate functions only in the column list of the SELECT clause and in the
WHERE clause of a SELECT statement.
D.
You can use aggregate functions on a table, only by grouping the whole table as one single
group.
E.
You can pass column names, expressions, constants, or functions as parameters to an
aggregate function.
F.
You cannot group the rows of a table by more than one column while using aggregate
functions.
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.
B,E
A,D
A is wrong – as aggregate functions cant be used in where clause of select statement
so I think D and E correct
Sorry, B and E coz D says “You can use aggregate functions on a table, ONLY by grouping the whole table as one single group.” but you can group table in many other ways and use aggregate functions