How to get top records in Mongodb?

Question

JavaScript

Hello, do not judge strictly, but how to get the top 50 records by the number of mentions through mongoose, for example, there is a type base

[{
name: "n1",
text: "n1"
},
{
name: "n1",
text: "n1"
},
{
name: "n2",
text: "n2"
},]

in the end i need an array like

[{
name: "n1",
text: "n1"
count: 2
},
{
name: "n2",
text: "n2",
count: 1
}]

in sql it would be like

SELECT name, text, COUNT(name) AS `count` 
FROM table
GROUP BY name, text

Answer 1

https://mongoosejs.com/docs/api/aggregate.html#agg...