Decision Support Systems For Business Intelligence
    by Vicki L. Sauter

 
 

Table 3.5
SQL Summary Operations

AVG()
COUNT()

FIRST()
LAST()
MAX()
MIN()
SUM()

calculates the average value of that attribute
identifies the number of records for which there is data on that attribute
identifies the first record
identifies the last record
identifies the largest value of the specific attribute
identifies the smallest value ofthe specific attribute
computes the sum of all values of the specific attribute

 

   Page Owner: Professor Sauter (Vicki.Sauter AT umsl.edu)