Show category_id, product_name and price of the two most expensive products
in each category. When two products have the same price, the one with the lower product_id
comes first.
End your query with ORDER BY category_id, price DESC, product_name.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
Show category_id, product_name and price of the two most expensive products
in each category. When two products have the same price, the one with the lower product_id
comes first.
End your query with ORDER BY category_id, price DESC, product_name.
| products |
|---|
| product_id (PK) |
| product_name |
| category_id (FK) |
| price |
| category_id | product_name | price |
|---|---|---|
| 1 | VoltBook Air 14 Laptop | 68990.00 |
| 1 | PixelTab 11 Tablet | 32999.00 |
| 2 | Mystery Thriller Box Set | 1799.00 |
| 2 | UPSC Mains Guide 2026 | 1299.00 |
| 3 | Denim Jacket | 2499.00 |
| 3 | Classic White Sneakers | 1999.00 |
| 4 | Air Fryer 4.5L | 8999.00 |
| 4 | Ceramic Dinner Set (18pc) | 3499.00 |
| 5 | Dumbbell Set 20kg | 2799.00 |
| 5 | Whey Protein 1kg | 2499.00 |
| 6 | Matte Lipstick Set (6) | 799.00 |
| 6 | Vitamin C Serum 30ml | 649.00 |
| 7 | Assorted Dry Fruits 1kg | 1099.00 |
| 7 | Basmati Rice 5kg | 749.00 |
| 8 | RC Stunt Car | 1999.00 |
| 8 | Building Blocks 250pc | 1499.00 |
Run query to see output