~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/aggregatefunctions.rst

• browse files at revision 2063
• compare with another revision
• download diff
• download tarball
• view history from revision 2063

Show diffs side-by-side

added

removed

docs/aggregatefunctions.rst

 

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'

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1