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 Functions
SQL 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:
This SQL Statement with aggregate functions is executed:
Here is the result.
|HOME | SQL OVERVIEW | SQL BASICS | SQL ADMINISTRATION | SQL ADVANCED | SQL SYNTAX|
|Copyright© 1999-2014, First Place Software, Inc.|