可以用
select first(bs_flag) from t group by segmentby(first, bs_flag.rowNo(), bs_flag)
或
select first(bs_flag), first(bs_flag.rowNo()) from t group by eachPre(ne, bs_flag).cumsum()
可以用
select first(bs_flag) from t group by segmentby(first, bs_flag.rowNo(), bs_flag)
或
select first(bs_flag), first(bs_flag.rowNo()) from t group by eachPre(ne, bs_flag).cumsum()