mysql GROUP BY count(*) 数据库按照月份分组在同一张表中 计算数量
SELECT count(t.counts) FROM ( SELECT count(*) counts FROM sm_order where 1 = 1 <if test="user_id != null and user_id !=''"> and sm_order.user_id = #{user_id} </if> GROUP BY DATE_FORMAT(create_time, '%Y-%m') ) t
原创
2017-05-17 10:50:24 ·
907 阅读 ·
0 评论