柳暗花明笔记

    SQL having语句,分组条件过滤

    所属分类:[ linux&mysql ] 猫哲学家 发表于:2012-08-27 17:52 浏览:473

    SELECT count(supplier_code) as count,`sku`,`supplier_code` FROM `product_supplier`  group by `sku` having count(supplier_code)>1 order by count desc 
    标签: mysql 
    上一编文章 安装Ubuntu 出现no root file system is defined.Please correct this from the partitioning menu 下一编文章 php的$ch = curl_init(); post请求
    最近文章
    发表评论