表td id VARCHAR2(256) 用户id
time VARCHAR2(256) 时间
flag VARCHAR2(256) 0来电,1停电
计算 停电时长,使用了 lead函数
select t1.id,t1.time,t1.flag,t1.next_time from (select t.id id,t.time,t.flag,
lead(t.time, 1, null) over(partition by t.id order by t.id) next_time
from td t
order by t.id,t.time asc) t1 where t1.flag='1'
记录下来以免遗忘