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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

SUM

A

SUM: This function calculates the sum of values in a specified column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

AVG

A

AVG: This function calculates the average of values in a specified column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

MIN

A

MIN: This function returns the minimum value from a specified column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

MAX

A

MAX: This function returns the maximum value from a specified column.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

HAVING

A

HAVING: This clause is used

  • to filter the results of a GROUP BY query
  • based on a condition.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly