说明:我有一个这样的表:
<表类>
ID
start_pt
end_pt
价值
添加
myresult
tbody><<tr>1 1 2 0 0 0 22 3 1 1 1 3 3 4 0 1 0 45 6 1 2 1 56 7 0 2 0 表类>
如果您正在尝试创建addition
列,那只是一个累积和:
select tu.*,
sum(value) over (order by id) as addition
from turbi."input" tu;