Syntexe description

UDA
N/A

Syntexe description

Hi,

i need help with this statement,
don't understand what does QUALIFY SUM(X) means and ROWS UNBOUNDED PRECEDING

if any one can give me an exemple this can be helpful

QUALIFY SUM(1) OVER (PARTITION BY toto ORDER BY tata ASC, ROWS UNBOUNDED PRECEDING) = 1

tks