7,714
社区成员
发帖
与我相关
我的任务
分享
select a,b,(select sum(b) from Table1 s where s.a<t.a and 2>(select count(*) from Table1 where a>s.a and a<t.a))
from Table1 t
select t1.a,t1.b,max(t2.b)+max(t3.b)
from (表 t1 left join 表 t2 on t1.a>t2.a)
left join 表 t3 on t2.a>t3.a
group by t1.a,t1.b
select t1.a,t1.b,t2.b+t2.b
from (表 t1 left join 表 t2 on t1.a=t2.a+1)
left join 表 t2 on t1.a=t3.a+2