sql 通过 两个区间统计分组和,完成sql的分组查询,两个列明拼接-开发小记
//包括外层进行分组-也可以在里面进行分组SELECT *,SUM(countSum) as countSum1 from (SELECT count_sum as countSum ,//数量 elt(INTERVAL (count_sum,0, 8, 16, 48 ), '8','9-16','17-48','48+' ) AS countSumLevel, FROM_UNIXTIME(createtime, '%Y-%m-%d'), DATEDIFF(FROM_UNIXTIME(e
原创
2022-04-21 20:41:17 ·
854 阅读 ·
0 评论