What are aggregate and scalar functions?

Total Post:55

Points:275

 167  View(s)
Ratings:
Rate this:
  1. What are aggregate and scalar functions?

    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.

Answer