fantasy2100
fantasy2100
"SELECT * FROM t1" current output: 1,6,2,2 expect output: 1,3,2,2
> It is sum... should be 6... sum and last_non_null_value are both aggregate functions. The result of sum is 6, why is the result of last_non_null_value not 3?
> > > It is sum... should be 6... > > > > > > sum and last_non_null_value are both aggregate functions. The result of sum is 6, why is...
@dark2momo Thank you very much for your reply, your explanation is very clear. I have one more question about `reordering the rows based on the sequence-group field`. Consider the following...