根据volume列计算f1列,不用循环怎么实现呢
以下代码可以实现你这边的需求,请参考:
t = table(10 7 13 6 4 8 7 3 6 as volume)tmp = select volume, iif(deltas(volume)>0, rowNo(volume), NULL) as flag from ttmp.bfill!()select volume, cumrank(volume) from tmp context by flag