db.getCollection('Transaction').aggregate([ {"$group" : { "_id": "$transactionNo", "count": { "$sum": 1 }, "ids":{"$push":"$_id"} } }, {"$match": {"_id" :{ "$ne" : null } , "count" : {"$gt": 1} } } ])
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter