Question

In SQL, ____ is an aggregate function

Answer 1

Answer:

count( ),sum( ),min( ),max( ),avg( )

Answer 2

Answer:

Aggregate function

1) Count()

2) Sum()

3) Avg()

4) Min()

5) Max()

Explanation:

SQL is an DBMS Language stand for structure query language.

Aggregate function:

• Aggregate function in SQL performs a calculation on multiple values and returns a single value.
• SQL provides many aggregate functions that include:

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.

• An aggregate function ignores NULL values when it performs the calculation, except for the count function.

#SPJ3