orders-mongodb-query

db.orders.aggregate([
  {
    $group: {
      // collect ids of the documents, that have same emrooz_idue 
      // for a given key ('emrooz_id' prop in this case)
      _id: '$emrooz_id',
      ids: {
        $push: '$_id'
      },
      // count N of duplications per key
      totalIds: {
        $sum: 1,
      }
    }
  },
  {
    $match: {
      // match only documents with duplicated emrooz_idue in a key
      totalIds: {
        $gt: 1,
      },
    },
  },
  {
    $project: {
      _id: false,
      documentsThatHaveDuplicatedValue: '$ids',
    }
  },
  {
  $lookup: {
    // note, you need to use same collection name here
    from: 'orders', 
    localField: 'documentsThatHaveDuplicatedValue',
    foreignField: '_id',
    as: 'documentsThatHaveDuplicatedValue'
  }
}
]);