Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

SQL > SQL Aggregate Functions > Flashcards

SQL Aggregate Functions Flashcards

(5 cards)

Start Studying
1
Q

The number of rows containing non-null values

A

COUNT

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

The minimum attribute value encountered in a given column

A

MIN

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

The maximum attribute value encountered in a given column

A

MAX

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

The sum of all values for a given column

A

SUM

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

The arithmetic mean (average) for a specified column

A

AVG

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

SQL (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions