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 评论