SQL Aggregate Functions Flashcards
1
Q
What is select for?
A
The SELECT statement is used to select data from a database. The data returned is stored in a result table, called the result-set.
2
Q
Returns the average value
A
AVG ()
3
Q
Returns the number of rows.
A
Count()
4
Q
Returns the first value.
A
First()
5
Q
Returns the last value.
A
Last()
6
Q
Returns the largest value.
A
MAX()
7
Q
Returns smallest value.
A
MIN()
8
Q
Returns the sum.
A
SUM()
9
Q
What is Aggregate functions for?
A
SQL aggregate functions return a single value, calculated from values in a column.
