在SAP HANA表中按小时分组
您可以尝试此方法将时间转换为日期和小时格式-
select to_varchar(time, 'YYYY-MM-DD'), hour(time), sum(r_time) as r_time, sum(p_time) as p_time from t1 group by date(time), hour(time) order by to_varchar(time, 'YYYY-MM-DD'), hour(time);
您也可以尝试将Series_Round()与groupby子句一起使用。
select SERIES_ROUND(time, 'INTERVAL 1 HOUR') as time, sum(r_time) as r_time, sum(p_time) as p_time from t1 group by SERIES_ROUND(time, 'INTERVAL 1 HOUR') order by SERIES_ROUND(time, 'INTERVAL 1 HOUR');
热门推荐
10 牛年公司新年祝福语简短
11 生日奥特曼可爱祝福语简短
12 新年简短祝福语给亲人
13 搞笑英译祝福语简短句
14 女儿出阁的祝福语简短
15 牛年大气简短的祝福语
16 孙子生日祝福语简短精辟
17 弟弟考上军校祝福语简短
18 朋友出国旅游祝福语简短