sql查询同一张表不同条件下的合计总数

select   (select count(business_status) from  business_express a where  business_status='TS'   ) as TS,  +
   (select count(business_status) from business_express b where business_status='DDDQ' ) as DDDQ
原文地址:https://www.cnblogs.com/xujiating/p/14918789.html