Database
[{"_id":ObjectId("6332c4d8a813124264860f83"),"prefixStr":"ABCD","startRange":1,"endRange":5,"createdate":ISODate("2022-09-27T09:39:36.319Z"),"__v":0},{"_id":ObjectId("6332c4d8a813124264860f84"),"prefixStr":"ABCD","startRange":1,"endRange":5,"createdate":ISODate("2022-09-27T09:39:36.319Z"),"__v":0},{"_id":ObjectId("6332c4d8a813124264860f85"),"prefixStr":"ABCD","startRange":1,"endRange":5,"createdate":ISODate("2022-09-27T09:39:36.319Z"),"__v":0},{"_id":ObjectId("6332c4d8a813124264860f86"),"prefixStr":"ABCD","startRange":1,"endRange":5,"createdate":ISODate("2022-09-27T09:39:36.320Z"),"__v":0},{"_id":ObjectId("6332c4d8a813124264860f87"),"prefixStr":"ABCD","startRange":1,"endRange":5,"createdate":ISODate("2022-09-27T09:39:36.320Z"),"__v":0},{"_id":ObjectId("6332c4e1a813124264860f88"),"prefixStr":"ABCD","startRange":11,"endRange":15,"createdate":ISODate("2022-09-27T09:39:45.739Z"),"__v":0},{"_id":ObjectId("6332c4e1a813124264860f89"),"prefixStr":"ABCD","startRange":11,"endRange":15,"createdate":ISODate("2022-09-27T09:39:45.743Z"),"__v":0},{"_id":ObjectId("6332c4e1a813124264860f8a"),"prefixStr":"ABCD","startRange":11,"endRange":15,"createdate":ISODate("2022-09-27T09:39:45.746Z"),"__v":0},{"_id":ObjectId("6332c4e1a813124264860f8b"),"prefixStr":"ABCD","startRange":11,"endRange":15,"createdate":ISODate("2022-09-27T09:39:45.747Z"),"__v":0},{"_id":ObjectId("6332c4e1a813124264860f8c"),"prefixStr":"ABCD","startRange":11,"endRange":15,"createdate":ISODate("2022-09-27T09:39:45.748Z"),"__v":0},{"_id":ObjectId("6332c4eaa813124264860f8d"),"prefixStr":"ABCD","startRange":21,"endRange":25,"createdate":ISODate("2022-09-27T09:39:54.203Z"),"__v":0},{"_id":ObjectId("6332c4eaa813124264860f8e"),"prefixStr":"ABCD","startRange":21,"endRange":25,"createdate":ISODate("2022-09-27T09:39:54.204Z"),"__v":0},{"_id":ObjectId("6332c4eaa813124264860f8f"),"prefixStr":"ABCD","startRange":21,"endRange":25,"createdate":ISODate("2022-09-27T09:39:54.205Z"),"__v":0},{"_id":ObjectId("6332c4eaa813124264860f90"),"prefixStr":"ABCD","startRange":21,"endRange":25,"createdate":ISODate("2022-09-27T09:39:54.207Z"),"__v":0},{"_id":ObjectId("6332c4eaa813124264860f91"),"prefixStr":"ABCD","startRange":21,"endRange":25,"createdate":ISODate("2022-09-27T09:39:54.208Z"),"__v":0},{"_id":ObjectId("6332c623edb18941f8aeabea"),"prefixStr":"ANKT001","startRange":0,"endRange":0,"createdate":ISODate("2022-09-27T09:45:07.570Z"),"__v":0}]
Query
db.collection.aggregate([{$group:{_id:"$prefixStr",range:{$addToSet:{start:"$startRange",end:"$endRange"}}}}])