A select statement that includes aggregate functions is often called a summary query.
Summary Query:
In contrast to simple queries, summary queries are used to extract summary data items for groups of records rather than detailed record sets. This query type is particularly important in accounting because payroll reports are based on summarizing transactional data.
Summary queries are used for:
- Finds the total number of records in the query.
- Get the number of records in the group.
- Finds the column sum of a set of records within a group.
- Find the column sum of all records in the query.
- Searching for minimum or maximum value in a range of values.
- Finding minimum or maximum value for all records in query.
- Finding the average of all records in the query.
- Finding the column average of all records in a group.
- Finds rows that contain duplicate values.
- Finding rows that contain unique values.
- Finds rows that match the average, minimum, or maximum value of the column.
Learn more about Summary Query here:
brainly.com/question/28478961
#SPJ4
