Min

Table of Contents



The min function computes the minimum value of a numeric field within a specified schema, working on the values in the documents of that field. It's utilized alongside the SELECT statement to fetch the minimum of values in the designated field across the documents within the schema.


round-pushpin Selects documents from the FlatTranslate schema and determines the minimum value of Id.
SELECT
    German,
    Min(Id)
FROM
    WordList:FlatTranslate
WHERE
    English LIKE 'Cat%'
GROUP BY
    German




Home
The home page
SQL :: Aggregate Functions
Aggregate functions are used to evaluate multiple rows when collapsing a group of documents.
SQL :: Avg
Computes the average value of a numeric field within a specified schema.
SQL :: Count
Tallies the occurrences of a specific field within a given schema.
SQL :: Group By
Group by allows you to select a result set and collapse it by a set of given fields.
SQL :: Max
Computes the maximum value of a numeric field within a specified schema.
SQL :: Sum
Computes the total or summation value of a numeric field within a specified schema
SQL::Keywords
A breakdown of all high-level statements available via the query handler.