oracle按15分钟统计数据,统计每15分钟内的数据量

大家好：

小弟遇到一个关于数据统计方面的问题。具体这样：统计每15分钟内的数据量(从晚上0点开始算，就是00:00,00:15,00:30,00:45.....23:30,23:45)

想得到如下效果

时间点       SUM

00:00         1

00:15         10

00:30         10

00:45          .

。               .

。

。

23:30          5

23:45          8

===================

测试数据

create table TEST0823A

(

DEALTIME DATE,

ID       VARCHAR2(124)

)

;

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:22:05', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e0469-003e');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:24:27', 'dd-mm-yyyy hh24:mi:ss'), '12e-0c42f1c5-0da9');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:24:27', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e0469-003e');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:31:12', 'dd-mm-yyyy hh24:mi:ss'), '12e-0c42f1c5-0da9');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:32:33', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e0469-003e');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:35:19', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e0469-003e');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:35:19', 'dd-mm-yyyy hh24:mi:ss'), '12e-0c42f1c5-0da9');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:38:10', 'dd-mm-yyyy hh24:mi:ss'), '12e-0c42f1c5-0da9');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:38:10', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e0469-003e');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:41:11', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e049e-0077');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:42:43', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e049e-0077');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:45:34', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e0469-003e');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:45:34', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e049e-0077');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:45:50', 'dd-mm-yyyy hh24:mi:ss'), '12d-c9374cad-06ae');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:47:44', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e049e-0077');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:55:44', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e04a5-007e');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:55:44', 'dd-mm-yyyy hh24:mi:ss'), '12d-c9374cad-06ae');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 17:59:10', 'dd-mm-yyyy hh24:mi:ss'), '12a-c44e04a5-007e');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 18:30:55', 'dd-mm-yyyy hh24:mi:ss'), '12c-c29e4ba5-1d9a');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 18:32:57', 'dd-mm-yyyy hh24:mi:ss'), '12c-c29e4ba5-1d9a');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 18:36:10', 'dd-mm-yyyy hh24:mi:ss'), '12c-c29e4ba5-1d9a');

insert into TEST0823A (DEALTIME, ID)

values (to_date('23-08-2011 18:41:50', 'dd-mm-yyyy hh24:mi:ss'), '12c-c29e4ba5-1d9a');

====================================

刚接触SQL不久，望各位多多支持！