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