Home > DeveloperSection > Interviews > What are aggregate and scalar functions?
 Ask Question

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

© Copyright © 2010 - 2019 MindStick Software Pvt. Ltd. All Rights Reserved

DO YOU WISH TO IMPROVE YOUR BUSINESS ?

Once you’ve signed up as a user for a sponsorship on MindStick network, you will receive sponsored posting opportunities to apply for. It’s a great way to promote your product as a brand.

Yes, help me to improve my business No thanks x