4 ms·
If I understand what you mean, it's supported everywhere that has windowing at all afaik. If you mean filtering the rows in the window, you can do 'sum(case wh
by bcoates 2y ago
If I understand what you mean, it's supported everywhere that has windowing at all afaik.
If you mean filtering the rows in the window, you can do 'sum(case when condition then value else null end) over (window)'; if you mean selecting rows based on the value of a window function you use 'qualify' where supported or a trivial subquery or CTE and 'where' (which qualify is just shorthand for)