SQL Aggregate Functions Flashcards Preview

SQL > SQL Aggregate Functions > Flashcards

Flashcards in SQL Aggregate Functions Deck (5)
Loading flashcards...
1

The number of rows containing non-null values

COUNT

2

The minimum attribute value encountered in a given column

MIN

3

The maximum attribute value encountered in a given column

MAX

4

The sum of all values for a given column

SUM

5

The arithmetic mean (average) for a specified column

AVG