SELECT *, count(goods_sn) as counter FROM table group by goods_sn order by goods_sn desc

------解决方案--------------------

SELECT COUNT(*) AS CT FROM A ORDER  BY id  DESC GROUP BY goods_sn;

试看看


------解决方案--------------------
SQL code

    SELECT count(*) as counter FROM table group by goods_sn order by goods_sn desc limit 10