Previous 
Next
What are SQL Aggregate Functions?The SQL Aggregate Functions are functions that provide mathematical operations. If you need to add, count or perform basic statistics, these functions will be of great help. The functions include:
Why Use SQL Aggregate Functions?The SQL Aggregate Functions are useful when mathematical operations must be performed on all or a grouping of values.
How To Use SQL Aggregate FunctionsSQL Aggregate Functions are used as follows. If a grouping of values is needed also include the GROUP BY clause. Use a column name or expression as the parameter to the Aggregate Function. The parameter, '*', represents all rows. SQL Aggregate Functions Syntax
SQL Aggregate Functions Example The following example Aggregate Functions are applied to the employee_count of the branch table. The region_nbr is the level of grouping. Here are the contents of the table:
Table: BRANCH
This SQL Statement with aggregate functions is executed:
Here is the result.
