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
posted @ 2021-06-22 15:28  许佳挺  阅读(927)  评论(0编辑  收藏  举报