db.collection.distinct()¶

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:

Parameters:	field (string) – Specifies the field for which to return the distinct values. query (document) – Specifies the selection `query` to determine the subset of documents from which to retrieve the distinct values.

Note

The db.collection.distinct() method provides a wrapper around the distinct command. Results must not be larger than the maximum BSON size.
When possible to use covered indexes, the db.collection.distinct() method will use an index to find the documents in the query as well as to return the data.

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:
copy
```
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:
copy
```
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:

copy

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

← db.collection.dataSize() db.collection.drop() →