Lesson 10 Flashcards
1
Q
Aggregate Function
A
Values of multiple rows are grouped together to perform a calculation and return a single value.
2
Q
Built-in Function
A
Function that is already available for use in SQL server.
3
Q
COUNT()
A
Returns the number of rows that match a specified criteria.
4
Q
SUM()
A
Returns the total sum of a numeric column.
5
Q
AVG()
A
Returns the average value of a numeric column.
6
Q
MIN()
A
Returns the smallest value of the selected column.
7
Q
MAX()
A
Returns the largest value of the selected column.
8
Q
Column Alias
A
Temporary name given to a column for readability.
9
Q
SELECT DISTINCT
A
Statement used to return only different values.
