请参考下面demo:
tb=table(1..20 as index,1..20 as val)
def mySum(tb,beg_idx,end_idx){
val=tb.val
index=tb.index
return sum(val[index>=beg_idx[0]and index <end_idx[0]])
}
select mySum(tb,beg_idx,end_idx) from table(1..5 as index,[1,4,7,12,15]as beg_idx,[4,9,14,15,19] as end_idx) group by index