窗口聚合问题

应用开发者专区
1

select ts,sum(daycap) as cap from
(select _wstart ts,last(daycap) as daycap,psid,devid from data_ps_zcnbq
psId = 10008 AND ts >= ‘2025-07-10 06:00:00’ AND ‘2025-07-10 21:00:00’ >= ts
PARTITION BY psid,devid
interval(45m))
PARTITION BY ts Tdengine taos数据库，为什么聚合后，第一条数据的时间是2025-07-10 05:45:00，而不是我过滤的时间从6点开始

2

INTERVAL(45m,15m) 加个偏移量就可以了