怎么用order by 查询 栏目下最贵的商品

如何用order by 查询 栏目下最贵的商品
首先想到的用max来做 ：  

html code

  select goods_id,goods_name,cat_id,shop_price from goods where shop_price in (select max(shop_price) from goods group by cat_id);     

欢迎大家阅读《怎么用order by 查询 栏目下最贵的商品》,跪求各位点评，by 搞代码

后来试着用order by 来做
[code=HTML]
select shop_price from goods order by shop_price desc;
+————+
| shop_price |
+————+
| 5999.00 |
| 3700.00 |
| 3010.00 |
| 2878.00 |
| 2625.00 |
| 2300.00 |
| 2298.00 |
| 2000.00 |
| 2000.00 |
| 1388.00 |
| 1337.00 |
| 1328.00 |
| 1311.00 |
| 1300.00 |
| 983.00 |
| 858.00 |
| 823.33 |
| 788.00 |
| 399.00 |
| 280.00 |
| 100.00 |
| 95.00 |
| 90.00 |
| 68.00 |
| 58.00 |
| 48.00 |
| 45.00 |
| 42.00 |
| 20.00 |
| 19.00 |
| 18.00 |
+————+
select shop_price from goods group by cat_id order by shop_price desc;
+————+
| shop_price |
+————+
| 3700.00 |
| 1388.00 |
| 823.33 |
| 399.00 |
| 95.00 |
| 90.00 |
| 68.00 |
| 48.00 |
| 20.00 |
+————+

[code=HTML]
发现出现的数据并不是最大的排在的前面，之后自以为是的加了个limit 1；结果只出现了一行数据
请问如何在此基础上得到每个栏目最大的数：
 [code=HTML]select shop_price from goods group by cat_id order by shop_price desc;[code=HTML]

——解决方案——————–
呵呵 自学的

喜欢 (0)赏

[搞代码]

分享 (0)