需求是在订单表中的商品 根据商品分组后根据数量进行倒叙 例如:
id | goods_id | goods_name | selelr_price |
1 | 3 | 电视 | 300 |
2 | 2 | 冰箱 | 500 |
3 | 3 | 电视 | 300 |
4 | 5 | 洗衣机 | 250 |
5 | 2 | 冰箱 | 500 |
6 | 3 | 电视 | 300 |
需要统计的数据格式如下:
goods_id | goods_name | seller_price | seller_num |
3 | 电视 | 300 | 3 |
2 | 冰箱 | 500 | 2 |
5 | 洗衣机 | 250 | 1 |
sql语句:
SELECT goods_id,goods_name,seller_price,COUNT(goods_id)AS sales_num FROM shopping_goods
GROUP BY goods_id ORDER BY sales_num DESC ;