在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 官宣新年祝福语简短