~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/aggregatefunctions.rst

  • Committer: Lee Bieber
  • Date: 2011-01-08 01:57:02 UTC
  • mfrom: (1994.4.21 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2063.
  • Revision ID: kalebral@gmail.com-20110108015702-d9mc4jwppb9vej94
Merge Marisa - latest doc updates, fix sphinx warnings

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
Aggregate Functions
 
2
===================
 
3
 
 
4
*SQL aggregate functions are calculated from values in a column, and return a single value.*
 
5
 
 
6
General syntax for aggregate functions is: ::
 
7
 
 
8
        SELECT "function type" ("column_name")
 
9
        FROM "table_name"
 
10
 
 
11
The following are examples of aggregate functions:
 
12
 
 
13
    * AVG() - Returns the average value
 
14
    * COUNT() - Returns the number of rows
 
15
    * FIRST() - Returns the first value
 
16
    * LAST() - Returns the last value
 
17
    * MAX() - Returns the largest value
 
18
    * MIN() - Returns the smallest value
 
19
    * SUM() - Returns the sum
 
 
b'\\ No newline at end of file'