Deutsch English
Alphabetical index
Array functions
CGI functions
Data types
Date functions
Debugging
Fulltext functions
Language elements
Numerical functions
Operators
Other functions
Ramtext functions
Selecting
Socket functions
Statistical functions
  • count()
  • max()
  • mean()
  • min()
  • sum()
    Stream functions
    String functions
    System functions
    Table functions
    Text functions
    Home    Overview    Search    Impressum    Contact    Members
    Topic complex Statistical functions
    Function sum()
    Short Returns the sum of an expression for a database evaluation
    Syntax SUM(numerischer_Ausdruck)
    Parameter numeric_expression: any expression with direct field accesses.
    Return Sum of every calculation of the numeric expression for every record of the evaluation.
    See also:
    max() min() mean() count()
    Description Example:

    VAR sum_income : REAL

    ...
    FINDANDMARK(db,'income<>0','sum_income:=SUM(income)')

    After the execution of the function in sum_income is the sum of all information about income.

    User comments:
    Write a comment:
    Name
    EMail
    Subject
    Text (Switch mode)

    Choose between
    the normal and the
    advanced editor.
    The advanced editor
    runs in IE 5+ and
    Mozilla 1.4+ only
    SPAM-Protection Please enter tdbengine in this field.

    tdbengine chat
    irc.tdbengine.org
    #tdbengine

       Copyright © 2003-2004 tdb Software Service GmbH
       Alle rechte vorbehalten. / All rights reserved
       Last changed: 21.10.2004
    {Fehler für :execmacro{execmacro="sessionspy"}