1.

What are aggregate functions in SQL?

Answer»

A function is a unit of CODE that is used for the purpose of reusability of a part of a program. An SQL aggregate function CALCULATES on a set of values and returns a single value. The function should RETURN a value. Some SQL aggregate FUNCTIONS are as follows:

  • AVG() - It returns the average of a set.
  • COUNT() - It returns the number of items in a set.
  • MAX() - It returns the maximum value in a set.
  • MIN() - It returns the minimum value in a set.
  • SUM() - It returns the sum of all or distinct values in a set.


Discussion

No Comment Found

Related InterviewSolutions