Which two are true about aggregate functions?

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

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.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Arc

Arc

A is wrong – as aggregate functions cant be used in where clause of select statement

so I think D and E correct

Arc

Arc

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