Count

Table of Contents

Overview

Example
See Also

Overview
The count function tallies the occurrences of a specific field within a given schema, working on the documents in that field. It's employed in conjunction with the SELECT statement to retrieve the count of occurrences of the designated field across the documents within the schema.

Example

Selects documents from the FlatTranslate schema and counts the value of Id.

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