Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The $sqrt
operator is used to return the square root of a specified number. It is commonly used in aggregation pipelines to perform mathematical calculations on numeric fields within documents.
{ $sqrt: <expression> }
Parameter | Description |
---|---|
<expression> |
Any valid expression that resolves to a number. |
The following example demonstrates how to calculate the square root of the fullSales
value within a document.
db.collection.aggregate([
{
$project: {
name: 1,
fullSales: 1,
sqrtFullSales: { $sqrt: "$sales.fullSales" }
}
}
])
This output includes the original fullSales value and its square root:
[
{ "_id": 1, "name": "Store A", "sales": { "fullSales": 100 }, "sqrtFullSales": 10 },
{ "_id": 2, "name": "Store B", "sales": { "fullSales": 225 }, "sqrtFullSales": 15 },
{ "_id": 3, "name": "Store C", "sales": { "fullSales": 400 }, "sqrtFullSales": 20 }
]
This example shows how to calculate the square root of the totalSales
for each sales category.
db.collection.aggregate([
{
$unwind: "$sales.salesByCategory"
},
{
$project: {
name: 1,
categoryName: "$sales.salesByCategory.categoryName",
totalSales: "$sales.salesByCategory.totalSales",
sqrtTotalSales: { $sqrt: "$sales.salesByCategory.totalSales" }
}
}
])
This output calculates the square root of the totalSales for each sales category:
[
{
"_id": 4,
"name": "Electronics Store",
"categoryName": "Laptops",
"totalSales": 144,
"sqrtTotalSales": 12
},
{
"_id": 5,
"name": "Fashion Outlet",
"categoryName": "Shoes",
"totalSales": 81,
"sqrtTotalSales": 9
}
]
- Review options for Migrating from MongoDB to Azure Cosmos DB for MongoDB (vCore)
- Read more about Feature compatibility with MongoDB