Get distinct values from a column in MongoDB?

To get distinct values from a column, use distinct() in MongoDB. Let us first create a collection with documents −

> db.demo128.insertOne({"Name":"Chris"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e30583d68e7f832db1a7f5d")
}
> db.demo128.insertOne({"Name":"David"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e30584068e7f832db1a7f5e")
}
> db.demo128.insertOne({"Name":"David"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e30584368e7f832db1a7f5f")
}
> db.demo128.insertOne({"Name":"Bob"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e30584668e7f832db1a7f60")
}
> db.demo128.insertOne({"Name":"Chris"});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e30584c68e7f832db1a7f61")
}

Display all documents from a collection with the help of find() method −

> db.demo128.find();

This will produce the following output −

{ "_id" : ObjectId("5e30583d68e7f832db1a7f5d"), "Name" : "Chris" }
{ "_id" : ObjectId("5e30584068e7f832db1a7f5e"), "Name" : "David" }
{ "_id" : ObjectId("5e30584368e7f832db1a7f5f"), "Name" : "David" }
{ "_id" : ObjectId("5e30584668e7f832db1a7f60"), "Name" : "Bob" }
{ "_id" : ObjectId("5e30584c68e7f832db1a7f61"), "Name" : "Chris" }

Following is the query to get distinct values from a column in MongoDB −

> db.demo128.distinct("Name");

This will produce the following output −

[ "Chris", "David", "Bob" ]

AmitDiwan

Published on 31-Mar-2020 11:47:52

• Related Questions & Answers
• Get distinct record values in MongoDB?
• MongoDB query to get distinct FirstName values from documents
• MongoDB query to get only distinct values
• Get Distinct Values with Sorted Data in MongoDB?
• Getting distinct values from object array in MongoDB?
• Get distinct first word from a string with MongoDB?
• How to get max values for distinct elements in MongoDB
• Python Pandas - Get unique values from a column
• Get the length of distinct values in an array with MongoDB
• Get the maximum count of distinct values in a separate column with MySQL
• How to get distinct list of sub-document field values in MongoDB?
• Get distinct first words in a string with MongoDB?
• Select distinct values from three columns and display in a single column with MySQL
• How to get unique values from MongoDB collection?
• Get distinct levels of array field in MongoDB?