今天帮公司项目“[url=http://www.7xigu.com]七夕谷情趣用品[/url]”商城的网站联盟做报表的时候需要利用在一条语句中count出不同的条件,特此记录一下
SELECT SUM( goods_amount ) AS money, count( * ) AS num, count(if(pay_status=1,true,null)) AS success, count(if(pay_status=2,true,null)) AS fall FROM `tab_order_info`
WHERE user_id = 2