Database
[{
"_id": "111",
"price": 100,
"name": "abc",
"category": "a"
},
{
"_id": "222",
"price": 90,
"name": "efg",
"category": "a"
},
{
"_id": "333",
"price": 80,
"name": "xyz",
"category": "a"
}
]
Query
db.collection.aggregate([{
"$project": {
"price": "$price",
"name": "$name",
"category": "$category",
"diff": {
"$abs": {
"$subtract": ["$price", 92]
}
}
}
}, {
"$sort": {
"diff": 1
}
}])