status.sql

本人在工程上收集的比较常用的oracle sql语句 有问题请发email:[e-mail]

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;