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

 
   This page was last modified on: 01/24/2011 19:45:46
   URL: https://umsl.edu/~sauterv/DSS4BI/Chapter3/Table5.html
   Page Owner: Professor Sauter (Vicki.Sauter AT umsl.edu)