- startTime:开始时间;
- endTime:结束时间;
- intervalMinutes:(开始时间-结束时间)/ 想分成的时间次数(分钟);
- fields1:任意分组字段。
select a.* from (
select distinct r.*,
floor((UNIX_TIMESTAMP(#{endTime}) - UNIX_TIMESTAMP(r.update_time))/60/#{intervalMinutes}) as groupNum
from table1 r
order by r.update_time desc
) as a
group by a.groupNum, a.fields1
order by a.fields1, a.update_time