Count

Table of Contents



Returns the number of values in each group. Count(0) and Count(*) count the documents in each group.

Numeric Count(AggregationArray valuesArray)

Without GROUP BY

When a query has aggregate functions but no Group By, all of the selected documents form a single group.


round-pushpin Counts the words for each language.
SELECT LanguageId, Count(0) as Words FROM WordList:Word GROUP BY LanguageId ORDER BY Count(0) DESC

round-pushpin Counts every document in a schema.
SELECT Count(*) FROM WordList:Word