Lesson 10: Aggregate Functions

Question 1

Aggregate Function

Answer 1

A function where the values of multiple rows are combined to use in a calculation to return a single value of significant meaning

Question 2

Built-in Function

Answer 2

A function (pre-defined program) that is already available for use in SQL Server (and many other software programs).

Question 3

COUNT()

Answer 3

A function that returns the number of rows that match a specified criteria.

Question 4

SUM()

Answer 4

A function that returns the total sum of a numeric column.

Question 5

AVG()

Answer 5

A function that returns the average value of a numeric column.

Question 6

MIN()

Answer 6

A function that returns the smallest value of the selected column.

Question 7

MAX()

Answer 7

A function that returns the largest value of the selected column.

Question 8

Column Alias

Answer 8

A temporary name given to a column to make the column name in the result-set more readable.

Question 9

SELECT DISTINCT

Answer 9

A statement used to return only different values.