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 ·
809 阅读 ·
0 评论