The aggregate functions are used to evaluate mathematical calculation and return single values. It 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.
Liked By
Write Answer
What are aggregate and scalar functions?
Join MindStick Community
You have need login or register for voting of answers or question.
Anonymous User
05-Jul-2019The aggregate functions are used to evaluate mathematical calculation and return single values. It can be calculated from the columns in a table. Scalar functions return a single value based on the input value.