Saved Bookmarks
| 1. |
What Are Aggregate And Scalar Functions? |
|
Answer» 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. 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. |
|