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
心再坚强也不要独自飞翔
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/LoganChen/p/14417495.html