What are aggregate and scalar functions?

Aggregate functions are used to evaluate mathematical calculation and return single values. This can be calculated from the columns in a table. Scalar functions return a single value based on the input value.

 

Example -.

 

Aggregate – max(), count – Calculated with respect to numeric.

 

Scalar – UCASE(), NOW() – Calculated with respect to strings.