怎么按时间间隔对数据分组

有表 如下我想用 一行数据 中 CreteTime 字段的值 和邻近的上下2个数据的 比较 超过 一个数值(比如超过10分钟) 作为条件, 求  sum(Mileage)  和  sum(CumulativeOil), 以及它们的起点 时间 和终点时间.比如 有500条数据, 其中数据第100行和101行的CreteTime 相差10分钟, 200行和 201行相差 30分钟,那么输出1-100的sum(Mileage) ,  1-100的sum(CumulativeOil), 行1的 CreteTime  ,行100的 CreteTime 
101-200的sum(Mileage) ,  101-200的sum(CumulativeOil), 行101的 CreteTime  ,行200的 CreteTime 
201-500的sum(Mileage) ,  201-500的sum(CumulativeOil), 行201的 CreteTime  ,行500的 CreteTime 
这样的sql 语句怎么写Mileage                                 CumulativeOil                           CreteTime
--------------------------------------- --------------------------------------- -----------------------
0.00                                    0.00                                    2012-11-25 13:44:01.987
0.00                                    0.00                                    2012-11-25 13:44:12.487
0.00                                    0.00                                    2012-11-25 13:44:22.777
0.00                                    0.00                                    2012-11-25 13:44:32.917
0.00                                    0.00                                    2012-11-25 13:44:43.167
0.00                                    0.00                                    2012-11-25 13:44:53.443
0.00                                    0.00                                    2012-11-25 13:45:03.567
0.00                                    0.00                                    2012-11-25 13:45:13.800
0.00                                    0.10                                    2012-11-25 13:45:24.067
0.00                                    0.00                                    2012-11-25 13:45:34.227
0.00                                    0.00                                    2012-11-25 13:45:44.450
0.00                                    0.00                                    2012-11-25 13:45:54.623
0.00                                    0.00                                    2012-11-25 13:46:04.790
0.00                                    0.00                                    2012-11-25 13:46:14.957
0.00                                    0.00                                    2012-11-25 13:46:25.263