Able to use most common SQL aggregate functions Flashcards
(7 cards)
COUNT
COUNT: This function counts the number of rows in a specified column or table.
SUM
SUM: This function calculates the sum of values in a specified column.
AVG
AVG: This function calculates the average of values in a specified column.
MIN
MIN: This function returns the minimum value from a specified column.
MAX
MAX: This function returns the maximum value from a specified column.
GROUP BY
GROUP BY:
- This clause is used in combination with aggregate functions
- to group rows based on
- one or more columns.
HAVING
HAVING: This clause is used
- to filter the results of a GROUP BY query
- based on a condition.