COUNT (NoSQL query)
APPLIES TO: NoSQL
Returns the count of the values in the expression.
Syntax
COUNT(<scalar_expr>)
Arguments
Description | |
---|---|
scalar_expr |
A scalar expression. |
Return types
Returns a numeric scalar value.
Examples
This first example passes in either a scalar value or a numeric expression to the COUNT
function. The expression is evaluated first to a scalar, making the result of both uses of the function the same value.
SELECT VALUE {
countScalar: COUNT(1),
countExpression: COUNT(2 + 3)
}
[
{
"countScalar": 1,
"countExpression": 1
}
]
This next example assumes that there's a container with two items with a /name
field. There's one item without the same field.
[
{
"name": "Horric socks",
"category": "socks"
},
{
"name": "Shinity socks",
"category": "socks"
},
{
"category": "socks"
}
]
In this example, the function counts the number of times the specified scalar field occurs in the filtered data. Here, the function looks for the number of times the /name
field occurs which is two out of three times.
SELECT VALUE
COUNT(p.name)
FROM
products p
WHERE
p.category = "socks"
[
2
]
Remarks
- This function benefits from a range index for any properties in the query's filter.
Related content
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για