Aggregate Functions Flashcards
(8 cards)
1
Q
Aggregate functions
A
Combine multiple rows together to form a single value of more meaningful information.
2
Q
Group By
A
Is a clause used with aggregate functions to combine data from one or more columns.
3
Q
Having
A
Limit the results of a query based on an aggregate property.
4
Q
COUNT()
A
Count the number of rows.
5
Q
SUM()
A
The sum of the values in a column
6
Q
MAX()/MIN()
A
The largest/smallest value
7
Q
AVG()
A
The average of the values in a column
8
Q
ROUND()
A
Round the values in the column.
