All SQL problems
EasyORDER BY
Top 3 most expensive products
The 3 highest-priced products, name + price, most expensive first.
- #limit
- #order-by-desc
Schema (SQLite, in-browser)
customers (id, name, city, signup_date) products (id, name, category, price) orders (id, customer_id, order_date, status) order_items (order_id, product_id, quantity)
Sample input
8 products
Expected shape
3 rows
sql-limit.sqlSQLite
Result
Press “Run query” to execute against the sample database.