sql 备忘

分组后统计

<span style="font-size:18px;">select count(*) from
(SELECT count(webUser_id) as userCount from organization_apply_order GROUP BY webUser_id) <span style="color:#ff0000;">a</span> WHERE userCount>=2;</span>

查询本月

 and date_format(createTime,'%Y-%m')=date_format(now(),'%Y-%m')