db.collection.distinct()

The db.collection.distinct() method finds the distinct values for a specified field across a single collection and returns the results in an array. The method accepts the following argument:

Consider the following examples of the db.collection.distinct() method:

• Return an array of the distinct values of the field ord_dt from all documents in the orders collection:

  db.orders.distinct( 'ord_dt' )
  

• Return an array of the distinct values of the field sku in the subdocument item from all documents in the orders collection:

  db.orders.distinct( 'item.sku' )
  

• Return an array of the distinct values of the field ord_dt from the documents in the orders collection where the price is greater than 10:

  db.orders.distinct( 'ord_dt',
                      { price: { $gt: 10 } }
                    )