Sum

Table of Contents

Overview

Example
See Also

Overview
The min function computes the total or summation 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 total of values in the designated field across the documents within the schema.

Example

Selects documents from the FlatTranslate schema and determines the total value of Id.

SELECT
    German,
    Sum(Id)
FROM
    WordList:FlatTranslate
WHERE
    English LIKE 'Cat%'
GROUP BY
    German