Deutsch English
Alphabetical index
Array functions
CGI functions
Data types
Date functions
Fulltext functions
Language elements
Numerical functions
Other functions
Ramtext functions
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 min()
    Short Returns the minimal value of an expression of a database analyse
    Syntax MIN(numerischer_Ausdruck)
    Parameter num_expression: any expression with direct field access.
    Return Minimal value of the single calculations of the numeric expression for every record of the analyse.
    See also:
    sum() max() mean() count()
    Description Example:

    VAR min_income, max_income : REAL
    ... FINDANDMARK(db,'income<>0','max_income:=MAX(income); min_income:=MIN(income)')

    After executing the function max_income has the highest value, min_income saves the smallest value of all income definitions.

    User comments:
    Write a comment:
    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

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