Which statement is true about aggregate functions?
Which statement is true about aggregate functions?
The MAX and MIN functions can be used on columns with character data types. This is because these functions can operate on different types of data, including numeric, date, and character data types, to return the highest or lowest values respectively within a set.
tested on a sample data
A. Aggregate functions can be nested to any number of levels. -> Can be nested upto one level only. B. The AVG function implicitly converts NULLS to zero. -> AVG function ignores NULLS. C. The MAX and MIN functions can be used on columns with character data types. -> True D. Aggregate functions can be used in any clause of a SELECT statement. -> It can't be used with where clause.