date问题
这条语句修改message partition的时间可以查询某天某分钟最高量的，请问怎么查询上一日的某分钟最高量的结果,而不需要每次修改message partition的时间?select max(count) from (select to_char(((FinishTime+28800)/86400+TO_DATE('19700101000000','YYYYMMDDHH24MISS')),'yyyy-mm-dd hh24:mi:ss')
time,count(*) count
from message partition(message_20120401) group by to_char(((FinishTime+28800)/86400+TO_DATE('19700101000000','YYYYMMDDHH24MISS')),'yyyy-mm-dd hh24:mi:ss')
order by count(*) desc);
页:
[1]