某时间段内的断点



测试：

drop table t;
create table t (t_name varchar2(10),start_time varchar2(100),end_time varchar2(100)); 

insert into t values('a','2017/02/12/16:11:23','2017/02/18/16:13:23');
insert into t values('b','2017/02/17/16:11:23','2017/02/20/16:16:23');
insert into t values('d','2017/02/19/16:11:23','2017/02/23/16:18:23');
insert into t values('e','2017/02/27/16:11:23','2017/02/29/16:18:23');
insert into t values('f','2017/03/02/16:11:23','2017/03/11/16:18:23');
insert into t values('g','2017/02/13/16:11:23','2017/02/15/16:11:23');
commit;
select * from t;

断点：

开始时间：215,223,229

结束时间：217,227,0302

 select end_time 断点的开始时间, next_start 断点的结束时间
  from (select t_name,
               start_time,
               end_time,
               lead(start_time) over(order by start_time) next_start,
               lead(end_time) over(order by start_time) next_end
          from t)
 where next_start > end_time;

结果：