### 1.4.12.7 Functions

The `cursor` objects currently support two function methods: `max()`, `min()` and `count()` as described below.

`max`( | table, column [,where=None][,values=[]])

  Returns the highest value of the column.
  table
    The name of the table
  column
    The name of the column
  where
    An optional where clause
  values
    Values to substitute for `?` parameters in the where clause.

`min`( | table, column [,where=None][,values=[]])

  Returns the lowest value of the column.
  table
    The name of the table
  column
    The name of the column
  where
    An optional where clause
  values
    Values to substitute for `?` parameters in the where clause.

`count`( | table, column [,where=None][,values=[]])

  Count the number of rows in the table matching where. If where is not specified, count all rows.
  table
    The name of the table
  column
    The name of the column
  where
    An optional where clause
  values
    Values to substitute for `?` parameters in the where clause.

For example consider the table below:

    # Numbers
    +--------+
    | Number |
    +--------+
    | 1      |
    +--------+
    | 2      |
    +--------+
    | 3      |
    +--------+

    >>> cursor.max(table='Numbers', column='Number')
    3
    >>> cursor.min(table='Numbers', column='Number')
    1
    >>> cursor.max(table='Numbers', column='Number', where="Number<?", values=[3])
    2