我要查询 t_order表的goodsid、count(goodsid)、total、左连接t_goods表的brand 和category 。 然后用goodsid (group by)分组 显示销量高的前12条数据(ORDER BY count(goodsid) DESC LIMIT 12 )
sql 语句如下
SELECT t_order.
goodsid,COUNT(t_order.
goodsid) AS 'goods_id_total' ,t_order.
totalAS 'total' , t_goods.
brand,t_goods.
categoryFROM t_order LEFT JOIN t_goods ON t_order.
goodsid=t_goods.
idGROUP BY goodsid ORDER BY goods_id_total DESC LIMIT 12
实现如下