What are aggregate functions?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What are aggregate functions?
Rating:
Aggregate functions are used to perform mathematical computations on a single or a range of values. SQL provides some aggregate functions that allow the user to compare the values in a database. The table below provides a summary of the aggregate functions:
| SUM | It returns the total from a given set of values. |
| AVG | It returns the average of a given set of values. |
| COUNT | It returns the number of items within a specified range. |
| MIN | It returns the least value within a specified range. |
| MAX | It returns the greatest value within a specified range. |
Rating:
Was this information helpful?
Other articles
- What is the getPrecision() method?
- What is the getColumnType() method?
- What is an integrity constraint?
- What are derived data?
- What is the ALTER command?
