SQL每日一题(20210817)
SQL每日一题(20220316)
select *,ifnull((select SUM(num) from T1207 b where b.id<a.id)+1,1) result
from T1207 a
select id, num,re, case when id = 1 then 1 else lag(re) over (order by id) end result
from (select id, num, sum(num) over (order by id) + 1 re from t1207) a
select id, num, sum(lag_num) over (order by id) as sum_lag
from (select id, num, lag(num, 1, 1) over () as lag_num from T1207) a