根据时间取余划分区间计算每个区间活跃人数

最新推荐文章于 2025-04-30 11:09:52 发布

丶可乐

最新推荐文章于 2025-04-30 11:09:52 发布

阅读量207

点赞数

文章标签： mysql

本文链接：https://blog.youkuaiyun.com/qq_42668140/article/details/115457587

版权

DB::query('select elt(interval((creat_time mod 86400),0,14400, 28800, 43200, 57600,72000,86400), "8到12", "12到16", "16到20", "20到24","24到4","4到8","8到12") as time_interval,count(id)  from user_login group by elt(interval((creat_time mod 86400),14400, 28800, 43200, 57600,72000,86400), "8到12", "12到16", "16到20", "20到24","24到4","4到8")')