按时间排序后,开始时间为连续同类型的开始时间,结束时间为连续同一类的的结束时间,连续同类型的值1累加,值2是一直累加。我用程序实现了,但是我个人觉得应该可以在oracle里直接实现获取的,可惜我不是很擅长oracle
开始时间                      结束时间            类型              值1                 值2
2012-01-01 23:21:21    2012-01-01 23:23:21         0                1                    1
2012-01-01 23:23:22    2012-01-01 23:59:59         1                1                    1
2012-01-02 00:00:00    2012-01-02 09:33:02         1                1                    1
2012-01-02 09:33:03    2012-01-02 10:33:02         0                1                    1
2012-01-02 10:33:03    2012-01-02 13:00:00         0                1                    1
2012-01-02 13:00:01    2012-01-02 13:03:00         2                1                    1
希望得到的值:
开始时间                      结束时间            类型              值1                 值2
2012-01-01 23:21:21    2012-01-01 23:23:21         0                1                    1
2012-01-01 23:23:22    2012-01-02 09:33:02         1                2                    3
2012-01-02 09:33:03    2012-01-02 13:00:00         0                2                    5
2012-01-02 13:00:01    2012-01-02 13:03:00         2                1                    6