Get the 10 most expensive products

MongoDB query compiled from plain English against the ecommerce sample schema, then verified by running it.

The compiled query

{
  "type": "find",
  "collection": "products",
  "sort": {
    "priceCents": -1
  },
  "limit": 10
}

How the compiled query works

Sorts by priceCents descending.
Returns at most 10 documents.

Things worth knowing

priceCents stores money as an integer number of cents — divide by 100 before displaying it.

Example results

Live output from running this query against the sample dataset.

name	priceCents	category	inStock
Standing Desk	32900	furniture	true
Noise-Cancelling Headphones	19900	electronics	true
Mechanical Keyboard	8900	electronics	true

Write this in plain English instead. Mask Databases compiles the sentence above into exactly this query at build time — no AI at runtime, and you can read the output in a diff.

Try it in the playground → No signup, runs in your browser.

Get the 10 most expensive products

The compiled query

How the compiled query works

Things worth knowing

Example results

Related queries