AGGREGATE FUNCTIONS Flashcards
values of multiple rows are grouped together
1
Q
AGGREGATE FUNCTIONS
A
values of multiple rows are grouped together
2
Q
COUNT():
A
return the number of rows that match a specified condition. It is often used to count the total number of rows in a table or the number of rows that meet specific criteria.
3
Q
SUM():
A
the total sum of a numeric column. It adds up all the values in the column and returns the sum.
4
Q
AVG()
A
used to return the average value of a numeric column
5
Q
MAX()
A
return the largest value of the selected column. It compares all values in the column and returns the largest one.
6
Q
MIN
A
return the smallest value of the selected column. It compares all values in the column and returns the smallest one
