select dtb,if(t is null,0,t) from(
select *,datediff(dtb,dta) as t from
(select dt as dta,v as va from A where v=0) as a right join
(select dt as dtb,v as vb from A where v=0) as b on dta<dtb order by dtb,t) as c
group by dtb估计效率不行,但总算实现了
select *,datediff(dtb,dta) as t from
(select dt as dta,v as va from A where v=0) as a right join
(select dt as dtb,v as vb from A where v=0) as b on dta<dtb order by dtb,t) as c
group by dtb估计效率不行,但总算实现了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货