What are aggregate and scalar functions?

Total Post:51

Points:255
 36  View(s)
Ratings:
Rate this:
  1. Post:51

    Points:255
    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