msyql 去重的用法 DISTINCT
-- 第一种写法SELECT mm.goods_id, COUNT(mm.goods_sn) AS sn_timesFROM ( SELECT a.goods_id, a.goods_sn FROM goods_sku a WHERE a.sku_status = 1 AND a.sku_stock > 0 GROUP BY a.goods_id, a.goods_sn ORDER BY goods_id DESC ) mm
原创
2020-09-19 11:55:57 ·
143 阅读 ·
0 评论