Define aggregate and scalar functions.
- Aggregate Functions return a single value by operating against a group of values.
- Scalar functions operate against a single value.
Define aggregate and scalar functions.
The aggregate functions always return a single value, which is the result of a column values.
EX: SUM(),COUNT(),AVERAGE(),MIN(),MAX()
A scalar functions returns a single value based on the value given as argument to the function.
Ex: UCASE(), LCASE(),LEN(),NOW()
