Question

Which of the following is not the aggregate function? * avg( ) sum( ) lcase( ) count( )
​

Answer 1

Answer:

Icase is not the aggregate function

Explanation:

SQL Aggregate Functions

AVG – calculates the average of a set of values.

COUNT – counts rows in a specified table or view.

MIN – gets the minimum value in a set of values.

MAX – gets the maximum value in a set of values.

SUM – calculates the sum of values.

These are the aggregate Functions