sql-aggregates Flashcards

1
Q

What are some examples of aggregate functions?

A

count(),sum(),avg() (many more functions available)

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

What is the purpose of a group by clause?

A

when you want to isolate rows into a separate group and perform aggregate functions on those group of rows you can use group by clause

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