统计一下哪个goods_id出现的次数最多,用来做商品推荐算法
SELECT goods_id AS 'goods_id',COUNT(USER) AS 'user_num' FROM t_look GROUP BY goods_id
ORDER BY COUNT(USER) DESC LIMIT 10
先按照goods_id进行了分组
然后在按照数量 降序显示前十
统计一下哪个goods_id出现的次数最多,用来做商品推荐算法
SELECT goods_id AS 'goods_id',COUNT(USER) AS 'user_num' FROM t_look GROUP BY goods_id
ORDER BY COUNT(USER) DESC LIMIT 10
先按照goods_id进行了分组
然后在按照数量 降序显示前十