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