Question

Which is not an aggregate function
Sum
Round
Count
Avg

Answer 1

According to SQL, round isn't an aggregate function.

In SQL, functions are of two types:

• Single-row functions
• Mulitple-functions

Multiple-row functions are those functions that work on multiple rows and return a single value. They include sum, count, avg, min, max, etc.

• sum - returns the total value of the column.
• count - returns the number of records in the column.
• avg - returns the average value of the column.
• min - returns the minimum value of the column.
• max - returns the maximum value of the column.

Null values will have no effect on sum, min and max. It would ignore the null value and consider the rest.

If a column named Salary had two Null values out of 5 values, avg(Salary) would consider the remaining 3 values and divide it by 3.

If a column named Salary had two Null values out of 5 values, count(Salary) would consider the remaining 3 values and return 3.

To have a brief on single-row functions, refer to the link below.

brainly.in/question/37973198