WHERE, ORDER BY, LIMIT
SELECT * FROM orders WHERE status = 'delivered' ORDER BY createdAt DESC LIMIT 10;
db.orders.find({ status: "delivered" })
.sort({ createdAt: -1 })
.limit(10)- WHERE becomes the filter object.
- ORDER BY ... DESC becomes sort({ createdAt: -1 }).
| orderNumber | total |
|---|---|
| A-1001 | 9097 |
| A-1003 | 12999 |