找出价格最高的 5 个商品。
- 按
price降序排,价格相同时按product_id升序排,取前 5 行。 - 正好取 5 行:第 5 名有并列时,按上面的规则只保留
product_id小的那个(第二个 case 的并列正好跨过第 5 名)。
输入
products(product_id, name, category, price, cost, launched_on)
输出
列为 product_id, name, price,行顺序必须与上面的排序规则一致。
找出价格最高的 5 个商品。
price 降序排,价格相同时按 product_id 升序排,取前 5 行。product_id 小的那个(第二个 case 的并列正好跨过第 5 名)。输入
products(product_id, name, category, price, cost, launched_on)输出
列为 product_id, name, price,行顺序必须与上面的排序规则一致。
products shop/products
| # | product_idint64 | namestring | categorystring | pricefloat64 | costfloat64 | launched_ondate |
|---|---|---|---|---|---|---|
| 1 | 1 | Wireless Mouse | Electronics | 25.0 | 16.77 | 2025-05-07 |
| 2 | 2 | USB-C Hub | Electronics | 49.9 | 34.17 | 2025-07-27 |
| 3 | 3 | Bluetooth Speaker | Electronics | 89.0 | 61.47 | 2025-02-10 |
| 4 | 4 | Mechanical Keyboard | Electronics | 199.0 | 105.48 | 2024-09-19 |
| 5 | 5 | 4K Monitor | Electronics | 500.0 | 282.38 | 2024-07-10 |
| 6 | 6 | Noise-cancel Headphones | Electronics | 299.0 | 211.57 | 2025-01-14 |
| 7 | 7 | Python Cookbook | Books | 59.0 | 30.08 | 2025-09-15 |
| 8 | 8 | SQL Pocket Guide | Books | 39.9 | 22.14 | 2025-01-20 |
| 9 | 9 | 数据分析实战 | Books | 79.0 | 40.83 | 2024-12-15 |
| 10 | 10 | Clean Code | Books | 50.0 | 28.48 | 2025-03-13 |
| 11 | 11 | 统计学习方法 | Books | 99.0 | 70.22 | 2025-03-13 |
| 12 | 12 | Desk Lamp | Home | 45.0 | 24.99 | 2025-11-04 |
| 13 | 13 | Ceramic Mug | Home | 19.9 | 11.34 | 2025-12-02 |
| 14 | 14 | Throw Pillow | Home | 35.0 | 19.23 | 2024-06-29 |
| 15 | 15 | Wall Clock | Home | 99.0 | 47.98 | 2025-02-23 |
| 16 | 16 | Storage Box | Home | 29.9 | 15.06 | 2025-02-27 |
| 17 | 17 | Puzzle 1000pc | Toys | 129.0 | 59.53 | 2025-08-19 |
| 18 | 18 | Building Blocks | Toys | 199.0 | 110.19 | 2025-04-18 |
| 19 | 19 | RC Car | Toys | 359.0 | 208.55 | 2025-11-06 |
| 20 | 20 | Plush Panda | Toys | 89.0 | 43.14 | 2026-01-12 |
| # | product_idInt64 | nameString | priceFloat64 |
|---|---|---|---|
| 1 | 23 | Running Shoes | 699.0 |
| 2 | 5 | 4K Monitor | 500.0 |
| 3 | 19 | RC Car | 359.0 |
| 4 | 6 | Noise-cancel Headphones | 299.0 |
| 5 | 22 | Dumbbell Set | 249.0 |