新手求助!查询语句 表A里有字段 id(自增),order_id(订单id),goods_sn(产品编码),其他字段... 查询产品编码出现最多的前10个产品的语句怎么写呀?菜鸟求助 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 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;试看看 SELECT count(*) as counter FROM table group by goods_sn order by goods_sn desc limit 10 thinkphp用import引入的文件,没有办法读取 PHP去除BOM头后出现乱码 php global问题 结合apache 的p hp 伪静态URL怎么写? 【指教】 取出数组中最大值 phpMyAdmin 显示html效果如果改代码 专业建站空间!10元可建网站!!!!!!!!! 路径疑问? 求助!关于字符串替换的问题??? 执行带字段函数查询时出现错误,请知道以下SQL查询: 帮忙看一个小函数 不懂 php怎么创建mysql触发器???
SELECT COUNT(*) AS CT FROM A ORDER BY id DESC GROUP BY goods_sn;试看看
SELECT count(*) as counter FROM table group by goods_sn order by goods_sn desc limit 10