A support team might need to pull the most recent orders to troubleshoot customer issues. Using the orders table, return the 10 most recent orders (all columns), ordered by order_date descending.
orders
| column | type |
|---|---|
| id | INTEGER |
| customer_name | TEXT |
| total | NUMERIC |
| order_date | DATE |
| id | customer_name | total | order_date |
|---|---|---|---|
| 1 | Alice | 120.00 | 2024-01-15 |
| 2 | Bob | 45.50 | 2024-03-02 |
| 3 | Carol | 210.00 | 2023-11-30 |
| 4 | Dave | 75.00 | 2024-02-14 |
| 5 | Eve | 330.00 | 2024-03-10 |
| id | customer_name | total | order_date |
|---|---|---|---|
| 5 | Eve | 330.00 | 2024-03-10 |
| 2 | Bob | 45.50 | 2024-03-02 |
| 4 | Dave | 75.00 | 2024-02-14 |
| 1 | Alice | 120.00 | 2024-01-15 |
| 3 | Carol | 210.00 | 2023-11-30 |
Orders are sorted by order_date descending so the most recent appears first. With only 5 orders in this example, all are returned since the count is below the LIMIT 10 threshold.