"select rider_id, waybill_status as waybill_sta

"select rider_id, waybill_status as waybill_status ,count(id) as waybill_status_count, TUMBLE_START(ctime, INTERVAL '1' DAY) as wStart from (select id, min(ctime) as rowtime ,latest(status, utime) as waybill_status, latest(rider_id, utime) as rider_id from user group by id) group by TUMBLE(ctime, INTERVAL '1' DAY),waybill_status,rider_id"

问一下 想用状态表作为子表 外面嵌套窗口 如何实现呢 因为状态表group by之后 ctime会失去时间属性,有哪位大佬知道的？ 本问题来自阿里云开发者社区的【11大垂直技术领域开发者社群】。 点击这里欢迎加入感兴趣的技术领域群。