Oracle 统计下令

Oracle 统计命令
按小时

select to_char(timestamp, 'ww') a,sum(num) from udbstat group by to_char(timestamp,'ww');