MYSQL count 

select count(DISTINCT ORGANIZATION_ID), count(DISTINCT ORGANIZATION_ID, if (customerType=1 ,true,null)),count(if (customerType=1 and squareFootageGroup=1,true,null)) from exhibition_exhibitor_rel

 

posted @ 2021-02-19 18:12  alittlecomputer  阅读(28)  评论(0)  编辑  收藏  举报