查询一级类目下 2级 3级 4级 对应的数量
SELECT temp.cname,temp.rootcid, (SELECT COUNT(1) FROM show_tb_category t1 WHERE t1.flag=2 AND t1.rootcid=temp.rootcid)category2, (SELECT COUNT(1) FROM show_tb_category t1 WHERE t1.flag=3 AND t1.rootcid=temp.rootcid)category3, (SELECT COUNT(1) FROM show_tb_category t1 WHERE t1.flag=4 AND t1.rootcid=temp.rootcid)category4 FROM (SELECT rootcid,flag,cname FROM show_tb_category WHERE flag=1 ORDER BY cid) temp SELECT temp.cname,temp.root
阅读背景：
开发中用到的SQL
来源：互联网
分享到：
