4 ms·
SQL is only secondary in my work but I'd rather go with the explicit and verbose queries rather than with stuff with surprises like how the last_value gives wro
by extrememacaroni 6y ago
SQL is only secondary in my work but I'd rather go with the explicit and verbose queries rather than with stuff with surprises like how the last_value gives wrong results when used the way you'd expect i.e. the reverse of first_value.
- adilkhash 6y agoif you understand the window ranges, especially the default one there is no surprise at all