status.sql

来自「本人在工程上收集的比较常用的oracle sql语句 有问题请发email:l」· SQL 代码 · 共 8 行

select nn||'*1',to_char(to_date('2006-12-7 0:0:0','yyyy-mm-dd hh24:mi:ss')+nn*1/24,'yyyy-mm-dd hh24:mi:ss'),
to_char(to_date('2006-12-7 0:0:0','yyyy-mm-dd hh24:mi:ss')+(nn+1)*1/24,'yyyy-mm-dd hh24:mi:ss')
,sum(sended),sum(total) from (select trunc((stime-to_date('2006-12-7 0:0:0','yyyy-mm-dd hh24:mi:ss'))*24/1) as nn
,sended,total from status where stime>=to_date('2006-12-7 0:0:0','yyyy-mm-dd hh24:mi:ss') 
and stime<to_date('2006-12-8 0:0:0','yyyy-mm-dd hh24:mi:ss')) group by nn;